Lookup values with multiple criteria

[avinash21]

Sir,
I'm trying to give two criteria to match my data. But i'm unable to.
I have attached the picture.
Screenshot 2022-02-04 150056.png

I want the data that is in I2,J2 and K2.

Would appreciate someone guide me.
Thank you.

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[Glenn Kennedy]

For Excel 2010+

=IFERROR(AGGREGATE(14,6,B$2:B$10/($A$2:$A$10=$H2),1),"")

BtW, your title is a bit weak. Since you're an infrequent user of the site, I have changed it for you.

[avinash21]

Thank You Glenn Kennedy and AliGW. Sorry about the title and attachement.

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

[Glenn Kennedy]

You sent me a PM requesting an explanation:

=IFERROR(AGGREGATE(14,6,B$2:B$10/($A$2:$A$10=$H2),1),"")

Red: where this criterion is met in A2:A10
Cyan: retun these values
Green return the largest (the 1 at the end) one (change to 2 for second largest, etc)
Black, iferror return a blank.

That's it...

Ypu can also use Formula/formula auditing/evaluate formula to watch Excel proceed step-by-step.

[avinash21]

You sent me a PM requesting an explanation:

=IFERROR(AGGREGATE(14,6,B$2:B$10/($A$2:$A$10=$H2),1),"")

Red: where this criterion is met in A2:A10
Cyan: retun these values
Green return the largest (the 1 at the end) one (change to 2 for second largest, etc)
Black, iferror return a blank.

That's it...

Ypu can also use Formula/formula auditing/evaluate formula to watch Excel proceed step-by-step.

Thank you sir Glenn Kennedy.