Backwards Vlookup
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 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
Further reading: How to create many to many lookup? Case Sensitive VLOOKUP
