How to Vlookup Backwards

Something tricky today. Let's create some backwards VLOOKUP formula. It's quite easy, but not obvious. Here's an example.

Sample dataset for Vlookup

The sample data table shows the products and prices. You try to find the price.

Backwards VLOOKUP

Backwards Vlookup formula

Index match functions combination would be useful for you here.

The formula of reverse VLOOKUP is: =INDEX($C$3:$C$10,MATCH($F$3,$B$3:$B$10,0))

 

Explanation:

C column - prices - array where you have your values whose you are looking for.

B column - products - names of all products which prices you know.

F3 - name of the product, which price you are looking for.

 

Now you know that you can also do a reverse vlookup.

Further reading:
How to create many to many lookup?
Case Sensitive VLOOKUP