Try The DGET Function Instead of INDEXMATCH & XLOOKUP Share: Download MP3 Similar Tracks Make Excel Formulas Dynamic with the Hash Sign Kenji Explains Return Multiple Matching Results in Excel –What XLOOKUP Can't Do! Kenji Explains Try The SWITCH Function Instead of IF Statements Kenji Explains How To Use XLOOKUP With Multiple Criteria Dave Sylvester The Ultimate XLOOKUP Tutorial (The Best Excel Formula) Kenji Explains Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!) Leila Gharani Simplify ANY Excel Formula With LAMBDA Kenji Explains Excel DGET Function Solves 2 of Your VLOOKUP Problems Leila Gharani Better than XLOOKUP? Try SUPERXLOOKUP! Excel Off The Grid Mastering Excel: Top 10 Formulas You Need to Know Kenji Explains 5 Excel Secrets You'll Be Embarrassed You Didn't Know Excel Campus - Jon The Excel Tool That Does What PivotTables Can’t (File Included) MyOnlineTrainingHub Try The NEW GROUPBY Function Instead of Pivot Tables Kenji Explains TOP 10 Excel Formulas to Make You a PRO User Kenji Explains Data Analyst Explains When to Use VLOOKUP vs XLOOKUP vs INDEX MATCH Mo Chen Excel GROUPBY Hacks to Instantly Improve Your Reports! Leila Gharani The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more) Kenji Explains The Excel Functions Almost Everyone Overlooks (Better Than SUMIFS) MyOnlineTrainingHub Ultimate XLOOKUP Guide: 10 Tips You Need to Know! Excel Off The Grid