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.br br 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.