Looking up the information you need - an example with XLOOKUP and INDEX+MATCH

The XLOOKUP function can replace VLOOKUP and the INDEX and MATCH combination with much grace. This video shows a quick example of looking for the same information with XLOOKUP and then with INDEX+MATCH.

----------------------

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer

LIVE CLASSES on YouTube every week: https:www//youtube.com/celiaalvessolveexcel

Get access to the Live Classes EXERCISE FILES by joining our Telegram Group at https://t.me/celiaalvessolveexcel

Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia



Solve & Excel Consulting - https://solveandexcel.ca

LinkedIn: https://www.linkedin.com/in/celiajordaoalves

Facebook: https://www.facebook.com/solveandexcel

Twitter: @celia_excel

Instagram: @solveandexcel


#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA

-------------------------

#Excel #shorts #solveandexcel #microsoft365 #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #canada

Тэги:

#excel #msexcel #power_query #canada #solveandexcel #mississaguabiz #torontobiz #powerquery #dataanalysis #ms_excel_tutorial #ms_excel_course #ms_excel_data #VBA

Скачать видео