Between the Sheets, Episode 64: Excel’s Xlookup Function
After two years of this podcast, I realized I never covered Excel’s Xlookup function! Time to rectify that. Xlookup lets you use Excel like a mini database so you can query information from a dataset. It replaces the older Vlookup and Hlookup functions (still available for backwards compatibility). But creating
July 25, 2024
No Comments