Moderator, Air Canada; FlyerTalk Evangelist
Join Date: Feb 2015
Location: YYC
Programs: AC SE MM, FB Plat, WS Plat, BA Silver, DL GM, Marriott Plat, Hilton Gold, Accor Silver
Posts: 16,767
Wow, forum lounge thread way down on page 4...
Anyone here use Excel much? If so, curious what people are thinking of the new XLOOKUP function. Ages ago I started using COLUMN/ROW functions to avoid hard-coding the column/row number so that VLOOKUPs didn't break so easily, but they still have their limitations. Then I stated using INDEX+MATCH or OFFSET+MATCH to replace VLOOKUPs when I created new stuff. But this XLOOKUP looks super simple, might be quicker and easier than those. Only issue, as far as I can see, is lack of backward compatibility for people running older versions of Excel.