Have you ever wondered why VLOOKUP works only in one direction! What would you do if you are in a situation where you need to apply VLOOKUP in the opposite direction? Would you give a negative sign to the range_lookup to identify the column from where you need to pick the data? Well, not quite literally.
Excel gives us two amazing function (INDEX and MATCH) to take care of such a situation. You can combine these two functions to get the desired result for which you'd have wanted a reverse VLOOKUP function.
No comments:
Post a Comment