VLOOKUP vs XLOOKUP - Which One is Better?
Let's see how the new XLOOKUP function in Google Sheets holds up against the old VLOOKUP.
More information on XLOOKUP: https://sheetshelp.com/xlookup/
Video mentioned with informational tidbit: • Excel VLOOKUP Sorting Problem
Spreadsheet used: https://bit.ly/v_vs_x
Timestamps:
0:00 Intro
0:14 Simple lookups
2:55 Returning multiple values
4:28 Looking to the left
6:29 Not found message
7:54 Reverse search order (from the bottom up)
9:07 Next video - Named functions
#googlesheets #xlookup #vlookup