Tag: Google Sheets

XLOOKUP vs VLOOKUP: How to Use XLOOKUP (7 Examples) Short answer: XLOOKUP is the better choice in almost every case. You give it three things, what to find, where to look and what to return: =XLOOKUP(H2, A2:A6, B2:B6). Unlike VLOOKUP, it has no column number to break when someone inserts a column, it uses exact […]