INDEX & MATCH\n\nBefore XLOOKUP, INDEX and MATCH was the pro way to look up data. It is still essential for older versions of Excel.