STOP using VLOOKUP (and use this instead)

preview_player
Показать описание
Watch the FULL course on 7 lookup functions:

Lookup functions are REALLY popular in Excel because they allow you to “lookup” a value from a dataset, based off of the criteria that you enter.

Most people only focus on Vlookup, without realizing that there are far more powerful lookup functions available. In today’s video, I’ll walk you through the different lookup functions and which is the best to use.

⏱️ TIMESTAMPS
0:00 Intro
0:11 VLOOKUP Function
2:00 XLOOKUP Function
4:40 INDEX/MATCH Function

ABOUT THIS CHANNEL
Looking to level up your career in Finance & Accounting? You're in the right place. Each week I upload videos around Accounting, FP&A, and Excel to help you grow in your career and learn something new.

Don’t forget to subscribe!

🔎 FIND ME AT

➡️ Subscribe to my Newsletter!

🔗 FOLLOW ME ON SOCIAL
Get updates or reach out to Get updates on our Social Media Profiles!

#ExcelFunctions #Lookup #Lookupfunctions #Excel #Dashboards #Financials #accountingprofessionals #Tutorial #yourcfoguy
Рекомендации по теме
Комментарии
Автор

➡ Download the Excel Worksheet here!

yourcfoguy
Автор

Have.trouble understanding index match and you.say is.the.simpest.waaoooo do have a more.detail video for.index.match.thanks for.the.free.video

quameatu
Автор

Please share free Excel file.
Knowledge must be free

usmaniqbal
Автор

Well if you use the Vlookup the way you are using it for sure it is useless. In the same way if you compare the other 2 formulas you are using with a macro.

Mpetersable