正在加载视频...

视频加载失败

VLOOKUP basics explained in 60 seconds 🔍 #excel

35,257 次观看 • 1 年前 •via X (Twitter)

9 条评论

CheatSheets 的头像
CheatSheets1 年前

Step 1. Type =VLOOKUP(

CheatSheets 的头像
CheatSheets1 年前

Step 2. Select or type in the lookup_value

CheatSheets 的头像
CheatSheets1 年前

Step 3. Select the table/array that contains the lookup_value (in the leftmost column) and the desired result.

CheatSheets 的头像
CheatSheets1 年前

Step 4. Type the column number of the desired result.

CheatSheets 的头像
CheatSheets1 年前

Step 5. Type FALSE for an exact match or TRUE for an approximate match.

CheatSheets 的头像
CheatSheets1 年前

Don't waste time spending countless hours on manual, repetitive tasks in Excel 🚫 Join Miss Excel's FREE Masterclass to learn all of her favorite tips & tricks. In this fun power-packed 1 hour session, you'll learn her secret hacks for optimizing your data visualization skills to save you hours each week! Limited spots available! Register at our link in bio 🎉

MasterChief 的头像
MasterChief1 年前

Xloopup, dget

Ramrod ¹⁹⁰⁷ 🦜 1907 🦋¹⁹⁰⁷ 的头像
Ramrod ¹⁹⁰⁷ 🦜 1907 🦋¹⁹⁰⁷1 年前

Great aq

Alex Handley 的头像
Alex Handley1 年前

Excellent description. Thanks

相关视频