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 a lookup table with the Xlookup function is easier to use, it’s more powerful and it even has built-in error correction.
Excel formula: convert Roman numerals to regular Arabic numbers
Last year, I did a TikTok video blog post about Excel’s =ROMAN function (watch it here). It will convert any regular Arabic number to Roman.