One critical aspect to remember when using VLOOKUP is that it can only search for data in the first column of the table array. For this reason, it’s important to organize your data accordingly.

Mastering VLOOKUP with Copilot VLOOKUP allows you to search for a value in the first column of a table and return a corresponding value from another column in the same row.

INDEX with XMATCH returns an item from a range or array according to the first or last match it finds. Like XLOOKUP, it works with vertical and horizontal datasets, can search in any direction, and ...

The trick to using Excel's VLOOKUP effectively is knowing what commands and values to use in what order.