XLOOKUP vs VLOOKUP: Which Formula Should You Use?

XLOOKUP vs VLOOKUP compared on syntax, left-side lookups, and Excel version support, with a clear verdict for each situation.