How to Use VLOOKUP: A Step-by-Step Guide for Excel Beginners VLOOKUP is used to search and retrieve data from a specific column in a table For example, you can look up the price of a product in a database or find an employee’s name based on their employee ID Approximate and exact matching is supported, and wildcards (* ?) can be used for partial matches