offset/match have been there since day 1 AFAICR, that is Excel 4.0 or so, as well as index/match. Or at least they exist just fine in Spread32 which is a nice

offset/match have been there since day 1 AFAICR, that is Excel 4.0 or so, as well as index/match. Or at least they exist just fine in Spread32 which is a nice tiny spreadsheet tool that was first released in 1999 and born with Excel 4.0 compatibility target. I believe it is more the "culture change" you mention, the "new" function is Xlookup, introduced recently: https://www.powerusersoftwares.com/post/xlookup-just-killed-vlookup-everything-to-know-about-this-major-new-excel-function https://www.powerusersoftwares.com/post/xlookup-just-killed-...