Video wird geladen...

Video konnte nicht geladen werden

Zur Startseite

VLOOKUP basics explained in 60 seconds 🔍 #excel

35,257 Aufrufe • vor 1 Jahr •via X (Twitter)

9 Kommentare

Profilbild von CheatSheets
CheatSheetsvor 1 Jahr

Step 1. Type =VLOOKUP(

Profilbild von CheatSheets
CheatSheetsvor 1 Jahr

Step 2. Select or type in the lookup_value

Profilbild von CheatSheets
CheatSheetsvor 1 Jahr

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

Profilbild von CheatSheets
CheatSheetsvor 1 Jahr

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

Profilbild von CheatSheets
CheatSheetsvor 1 Jahr

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

Profilbild von CheatSheets
CheatSheetsvor 1 Jahr

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 🎉

Profilbild von MasterChief
MasterChiefvor 1 Jahr

Xloopup, dget

Profilbild von Ramrod ¹⁹⁰⁷ 🦜 1907 🦋¹⁹⁰⁷
Ramrod ¹⁹⁰⁷ 🦜 1907 🦋¹⁹⁰⁷vor 1 Jahr

Great aq

Profilbild von Alex Handley
Alex Handleyvor 1 Jahr

Excellent description. Thanks

Ähnliche Videos