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
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
Category
📚
Learning