Diese Funktionen ERSETZEN den SVERWEIS in Excel

► Subscribe to the channel: https://bit.ly/jakobnbr In this video, I'll show you how to use INDEX and MATCH, as well as XLOOKUP. Both are excellent alternatives to the VLOOKUP function in Microsoft Excel. Of course, I can't demonstrate every function in one video, but I hope I've given you the best possible introduction to the topic. ▬ More Videos ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ► Professional Dashboards in Excel    • Interaktives Dashboard in Excel erstellen ...   ► The Most Important Excel Functions    • 20 Excel Funktionen die JEDER können sollte   ► ALL my Excel Tips & Tricks    • Excel Tipps & Tricks   ▬ My Equipment ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ In the Video: ► Software: https://amzn.to/3eUCBNb ► Mouse: https://amzn.to/3ERJHwG ► Keyboard: https://amzn.to/3mPemof ► Monitor: https://amzn.to/3EMIxCJ ► Microphone: https://amzn.to/3t149cl ► Camera: https://amzn.to/3eQZpgS Thank you for your free support through these affiliate links! ▬ About this channel ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ I am a business education graduate from Austria and run an SEO & web design agency full-time. On this channel, you'll find tips, tricks, and tutorials about Microsoft products and productive work in the digital space. Subscribe to my channel: https://bit.ly/jakobnbr LinkedIn: https://bit.ly/jnbr_linkedin ▬ Timestamps ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 00:00 Intro 00:28 VLOOKUP Problems 02:07 Up to Excel 2019 05:34 From Excel 2021 & Office 365 08:48 Recommendation