Microsoft Excel — Hard
Key points
- XLOOKUP's search capability is not limited to the leftmost column
- It can return values from any column and handle errors with a not_found argument
- XLOOKUP supports multiple match modes, including exact and wildcard matches
- It can return arrays, making it more versatile than VLOOKUP
Ready to go further?
Related questions