Table of Contents
A VLOOKUP with two lookup values requires the use of a nested IF statement. The function will first use the first lookup value to find a match in the table array, and if that value is not found, it will then use the second lookup value to make the match. The result of the nested IF statement will be the result of the VLOOKUP. This can be useful when there are multiple possible lookup values that could yield a match in the table array.
You can use the following basic formula to perform a VLOOKUP with two lookup values in Excel:
=VLOOKUP(F1&F2,CHOOSE({1,2},A2:A10&B2:B10,C2:C10),2,FALSE)
This particular formula looks up the values in F1 and F2 in the ranges A2:A10 and B2:B10, respectively, and returns the corresponding value in the range C2:C10.
The following example shows how to use this formula in practice.
Example: Perform VLOOKUP with Two Lookup Values
Suppose we have the following dataset in Excel that shows the points scored by various basketball players:
Now suppose we would like to use a VLOOKUP function to find the points value that corresponds to a Team value of Mavs and a Position value of Center.
To do so, we can type the following formula into cell F3:
=VLOOKUP(F1&F2,CHOOSE({1,2},A2:A10&B2:B10,C2:C10),2,FALSE)
The following screenshot shows how to use this formula in practice:
The formula returns a value of 31.
This is the correct points value that corresponds to the player on the Mavs team who has a position of Center.
Note that we can change the values in column F to find the points value for a different player.
For example, if we change the Team to Spurs and the Position to Guard, the VLOOKUP function will automatically update to find the points value for this player:
