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