Loading video...
Video Failed to Load
How to VLOOKUP vs HLOOKUP 🧵
26,210 views • 1 year ago •via X (Twitter)
4 Comments

CheatSheets1 year ago
How to VLOOKUP: Step 1. Type =VLOOKUP( Step 2. Select the lookup_value (the value to look up). Step 3. Select the range of data where the lookup_value is in the leftmost column. Step 4. Type the column number of the result. Step 5. Type FALSE for an exact match.

CheatSheets1 year ago
How to HLOOKUP: Step 1. Type =HLOOKUP( Step 2. Select the lookup_value (the value to look up). Step 3. Select the range of data where the lookup_value is in the topmost row. Step 4. Type the row number of the result. Step 5. Type FALSE for an exact match.

Paul The Planner*1 year ago
XLookup is the way to go

Samuel 🥷1 year ago
Why Not XLOOKUP Instead?
