For example, for a Blue Medium T-shirt, VLOOKUP should return $16.00.
TheVLOOKUP functiondoes not handle multiple criteria natively.
There is no built-in way to supply multiple criteria.
Note: This example shows an advanced technique to handle multiple criteria with VLOOKUP.
If you have more basic needs,this formulatakes a simple approach with a helper column.
Other more flexible options includeINDEX and MATCHandXLOOKUP.
Background study
This article assumes you are familiar with the VLOOKUP function and Excel Tables.
The “Result” array shows that the 7th row in the table meets all three conditions.
The problem is that this array is not actually part of the table VLOOKUP needs as thetable_arrayargument.
We can do this with the CHOOSE function.
Normally, theCHOOSE functionis used to select a value by numeric position.
However, if we place the array in an Excel worksheet, the structure becomes clear.
Now we need to configure the VLOOKUP function.
The values provided to CHOOSE can include references.
Related videos
How to use VLOOKUP
