VlookUp for 2 Row Criteria

0

Hi. I have a question regarding vlookup function. I have 5 types of product in a row and 5 type process in a column. Every product has a different time of processing. I do data validation for product and process. how to do vlookup for both criteria? 

Any help would be appreciated.

Thanks

Answer
Discuss

Answers

0

This formula should do what you want. Please try it in cell K3 of your example. You can copy it down from there if needed.

=VLOOKUP($I3,$A$2:$E$9,MATCH($J3,$A$1:$E$1,0),FALSE)

I recommend that you replace the range address $A$2:$E$9 with a named range, possibly a dynamic one which expands automatically as items are added to your list.

Discuss
0

The alternative formula you can use for this as below

=INDEX(A3:E10,MATCH(I4,A3:A10,0),MATCH(J4,A2:E2,0))

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login