The New XLOOKUP Function for Excel + Video Tutorial
http://go.microsoft.com/fwlink/?LinkID=617350
WebSep 4, 2019 · The job of XLOOKUP is to find a value in a row (column) and return a value from an adjacent column (row) where a match is found. It's the same basic principle as VLOOKUP but includes some cool new features. XLOOKUP's Signature. Here is the signature (arguments) for XLOOKUP:
DA: 43 PA: 4 MOZ Rank: 54