Loading video...

Video Failed to Load

Go Home

VLOOKUP basics explained in 60 seconds ๐Ÿ” #excel

35,257 views โ€ข 1 year ago โ€ขvia X (Twitter)

9 Comments

CheatSheets's profile picture
CheatSheets1 year ago

Step 1. Type =VLOOKUP(

CheatSheets's profile picture
CheatSheets1 year ago

Step 2. Select or type in the lookup_value

CheatSheets's profile picture
CheatSheets1 year ago

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

CheatSheets's profile picture
CheatSheets1 year ago

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

CheatSheets's profile picture
CheatSheets1 year ago

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

CheatSheets's profile picture
CheatSheets1 year ago

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's profile picture
MasterChief1 year ago

Xloopup, dget

Ramrod ยนโนโฐโท ๐Ÿฆœ 1907 ๐Ÿฆ‹ยนโนโฐโท's profile picture
Ramrod ยนโนโฐโท ๐Ÿฆœ 1907 ๐Ÿฆ‹ยนโนโฐโท1 year ago

Great aq

Alex Handley's profile picture
Alex Handley1 year ago

Excellent description. Thanks

Related Videos