How to use VLOOKUP in Excel

1 225 671
Published on 25 Nov 2019, 21:29
In Excel, use VLOOKUP when you need to find things in a table or range by row. Learn more at the Excel Help Center:

The highly anticipated XLOOKUP function in Excel is generally available for all users across Windows, Mac, and Excel on the web. XLOOKUP is the successor to the iconic VLOOKUP function, which has been one of the most used functions in Excel.

XLOOKUP helps users find what they need more efficiently with fewer limitations, from being able to look up a value vertically and horizontally (and to the left!) to supporting column insertions and deletions and more. Learn more: