Video wird geladen...
Video konnte nicht geladen werden
VLOOKUP basics explained in 60 seconds 🔍 #excel
35,257 Aufrufe • vor 1 Jahr •via X (Twitter)
9 Kommentare

Step 1. Type =VLOOKUP(

Step 2. Select or type in the lookup_value

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

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

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

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 🎉

Xloopup, dget

Great aq

Excellent description. Thanks
