What is the VLOOKUP function mainly used for in MS Excel 365?

VLOOKUP (Vertical Lookup) is one of the most commonly used functions in MS Excel.
It searches for a value in the first column of a table and then returns a value from another column in the same row.
Example: If you have a list of product IDs and prices, you can use VLOOKUP to find the price of a specific product ID.
Key Takeaway
VLOOKUP is mainly used for looking up data vertically in a table and retrieving related information, not for totals, percentages, or pivot tables.