Nested VLOOKUP – Excel & Google Sheets

This tutorial will demonstrate how to perform a Nested VLOOKUP in Excel and Google Sheets. If you have access to the XLOOKUP Function, we recommend performing a nested XLOOKUP instead.

If you need to perform a lookup that is dependent on looking up another value, you can use a Nested VLOOKUP formula:

=VLOOKUP(VLOOKUP(E3,B3:C5,2,FALSE),B8:C10,2,FALSE)

 

Let’s walkthrough the formula:

First, we need to perform the 1^st VLOOKUP to extract the required lookup value (e.g., Product ID) for our main VLOOKUP:

=VLOOKUP(E3,B3:C5,2,FALSE)

 

Note: The VLOOKUP Function performs a vertical lookup in the first column of the table array starting from the top of the list going down (i.e., top-down). If it finds a match, it returns the corresponding value from the column described by the column index, and if not, it returns an error.

Next, we substitute the result to our main VLOOKUP and perform a lookup in another table:

=VLOOKUP(F3,B8:C10,2,FALSE)

 

Combining all of these results to our original formula:

=VLOOKUP(VLOOKUP(E3,B3:C5,2,FALSE),B8:C10,2,FALSE)

 

Nested VLOOKUP in Google Sheets

The formula works the same way in Google Sheets: