This tutorial explains how to perform a reverse VLOOKUP in Google Sheets.

**Example: Reverse VLOOKUP in Google Sheets**

Suppose we have the following dataset that shows the number of points scored by various basketball teams:

We can use the following **VLOOKUP** formula to find the number of points associated with the “Knicks” team:

=VLOOKUP("Knicks", A1:B9, 2)

Here’s what this formula does:

- It identifies
**Knicks**as the value to find. - It specifies
**A1:B9**as the range to analyze. - It specifies that we’d like to return the value in the
**2nd**column from the left.

Here’s how to use this formula in practice:

This formula correctly returns the value of **99**.

However, suppose we instead want to know which team is associated with a points value of **99**.

We can use the following **reverse VLOOKUP** formula:

=VLOOKUP(99, {B2:B9, A2:A9}, 2)

Here’s what this formula does:

- It identifies
**99**as the value to find. - It specifies
**B2:B9**and**A2:A9**as the ranges to analyze. - It specifies that we’d like to return the value in the
**2nd**column from the right.

Here’s how to use this formula in practice:

The formula correctly identifies the **Knicks** as the team with a points value of **99**.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

How to Use a Case Sensitive VLOOKUP in Google Sheets

How to Count Cells with Text in Google Sheets

How to Replace Text in Google Sheets

How to Filter for Cells that Contain Text in Google Sheets