How to use VLOOKUP in Excel

Опубликовано: 25 Ноябрь 2019
на канале: Microsoft 365
2,571,273
4.7k

In Excel, use VLOOKUP when you need to find things in a table or range by row. Learn more at the Excel Help Center: https://msft.it/6004T9oO6

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: https://msft.it/6000Tay8y