200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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
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.
The alternative formula you can use for this as below
=INDEX(A3:E10,MATCH(I4,A3:A10,0),MATCH(J4,A2:E2,0))