Reverse Lookup with HLOOKUP | How to do Reverse Lookup in Excel

Published: 01 January 1970
on channel: Excel Ninja
1,374
22

In this video, I have explained how to use the #hlookup function to do a reverse lookup in excel. many times we need to lookup right to left which #vlookup can't do, so we use INDEX+MATCH functions, but #hlookup and #match can also be used to do the reverse lookup or right to left lookup.

To know more, follow the steps described in the video.

Follow the link to Subscribe to Excel Ninja👇
   / @excelninja1  

For more Excel videos visit the link below👇
   / exceluniverse  
------------------------------------------------------------

Insert Multiple Fields at Once in PivotTable👇
   • Insert Multiple Fields at Once in Piv...  

HLOOKUP Function in Detail👇
   • How to use HLOOKUP Function in Excel  
   • Reverse lookup in excel with HLOOKUP  

Calculate Age in Excel👇
   • DATEDIF Function | Calculate AGE in E...  

Create a Dynamic Calendar in Excel👇
   • How to Make Dynamic Calendar in Excel...  

Extract Unique List in Excel 2013👇
   • Dashboard Automation | Extract Unique...  

Auto Indexing in Excel👇
   • Auto Indexing in Excel | Get Serial N...  

Get Conditional Rank in Excel👇
   • How to Calculate RANK With Condition ...  

Download Practice File Here👇
https://mega.nz/file/typQxKpa#1aYbFHN...


Watch video Reverse Lookup with HLOOKUP | How to do Reverse Lookup in Excel online without registration, duration hours minute second in high quality. This video was added by user Excel Ninja 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,37 once and liked it 2 people.