Backwards Vlookup

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

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

Backwards VLOOKUP


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



C column - prices - array where you have your values which 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 vlookup in reverse order.