正在加载视频...

视频加载失败

How to VLOOKUP vs HLOOKUP 🧵

26,210 次观看 • 1 年前 •via X (Twitter)

4 条评论

CheatSheets 的头像
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.

CheatSheets 的头像
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* 的头像
Paul The Planner*1 年前

XLookup is the way to go

Samuel 🥷 的头像
Samuel 🥷1 年前

Why Not XLOOKUP Instead?

相关视频