正在加载视频...
视频加载失败
How to VLOOKUP vs HLOOKUP 🧵
4 条评论

CheatSheets1 年前
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 年前
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 年前
XLookup is the way to go

Samuel 🥷1 年前
Why Not XLOOKUP Instead?
