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 VLOOKUPThe 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 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 reverse vlookup.

Template

You can download the Template here – Download
Previous articleHow to automatically load the values into the drop-down list using VLOOKUP?
Next articleChart with combo box in Excel