Excel Famous function #HLOOKUP is very powerful while you trying to do reverse lookup your data. In Excel having two Functions #VLOOKUP & #HLOOKUP both are very user friendly to do lookup any types of database, and if you combined #MATCH Function with both functions, you no need to use any other lookup functions.
In this video I have use HLOOKUP to do reverse lookup and also use name range to lookup data dynamically. Watch the video till the end to know more.
Related Video #HLOOKUP Function Basic https://youtu.be/LRzfKmZjtKk #MATCH Functions https://youtu.be/eJNIGfZ6Hq0 #INDIRECT Function https://youtu.be/gMD8SepX17E Name Manager https://youtu.be/-5DC7j2dNzk #XLOOKUP Function https://youtu.be/HAnaj21dxyY
Download Practice File Here https://mega.nz/file/typQxKpa#1aYbFHN0HtWrmlP1wSQ0OpyP7bzHSMEsgohgnGl9vf4