VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links …
VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
Quick Reference Card: VLOOKUP refresher - Microsoft Support
VLOOKUP is one of the most popular, useful functions in Excel, but it’s hard to remember the formula if you don’t use it that often. If all you want is the syntax for VLOOKUP, here it is: To …
Look up values in a list of data in Excel - Microsoft Support
Look up data in Excel to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned. Use the VLOOKUP, HLOOKUP, INDEX, MATCH, and …
LOOKUP function - Microsoft Support
Watch this video about how to use VLOOKUP. If you are using Microsoft 365, use XLOOKUP - it's not only faster, it also lets you search in any direction (up, down, left, right).
Use Excel built-in functions to find data in a table or a range of ...
The VLOOKUP or Vertical Lookup function is used when data is listed in columns. This function searches for a value in the left-most column and matches it with data in a specified column in …
Lookup and reference functions (reference) - Microsoft Support
Jun 24, 2025 · Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.
How to correct a #VALUE! error in the VLOOKUP function
If you work with VLOOKUP, there is a good chance you may have run into the #VALUE! error several times. This topic lists the most common problems that may occur with VLOOKUP, and …
How to correct a #N/A error - Microsoft Support
In this case there is no "Banana" listed in the lookup table, so VLOOKUP returns a #N/A error. Solution: Either make sure that the lookup value exists in the source data, or use an error …
How to correct a #VALUE! error in the VLOOKUP function
If you work with VLOOKUP, there is a good chance you may have run into the #VALUE! error several times. This topic lists the most common problems that may occur with VLOOKUP, and …