@sdw.online: Here's an end-to-end Excel data project that includes XLOOKUPs and INDEX MATCHes, by Mo Chen. On YouTube, search "Mo Chen Excel project" and watch "The Only Excel Portfolio Project You Need". You build a coffee shop sales dashboard using pivot tables, XLOOKUPs and INDEX MATCH, plus data cleaning, pivot charts and slicers.