How to Do a Reverse Vlookup in Google Sheets

Step-by-Step Guide

1. 1

   Step 1: Prepare your data.

   In this example, we will lookup a value from column A, and output the corresponding value in column B.
   
   So our lookup "table" is A:
   B. , We will lookup a value in cell C1 for this example., The filter function helps you find a set of values inside of a column.
   
   In this case, the filter will return to us the set of rows that contain our value in C1.
   
   The filter part of the formula is: filter(ROW(A:
   A), A:
   A=C1)., The MAX part of the final formula is MAX(filter(ROW(A:
   A), A:
   A=C1))., The final formula is =INDEX(A:
   B, MAX(filter(ROW(A:
   A), A:
   A=C1)),2).
   
   The index function is looking up the row we found using filter inside of the specified table, and returning the corresponding value in column B, the second column, which is why the 2 is used.
2. 2

   Step 2: Figure out what value you want to lookup.

3. 3

   Step 3: Use the filter function.

4. 4

   Step 4: Get the highest row from the filter function by using the MAX function.

5. 5

   Step 5: Use the INDEX function to get the value out of the row you discovered using MAX and FILTER.

Detailed Guide

About the Author