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.

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 to more.

VLOOKUP finds a value, and then displays the data in a cell that corresponds to that value. Print this card for a handy list of the function's arguments.

You can try out these examples in your own Excel worksheet to learn how the LOOKUP function works. In the first example, you're going to end up with a spreadsheet that looks similar to this one:

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.

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 …

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 the possible …

Print a list of tips and techniques for avoiding #N/A and other errors in VLOOKUP.

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.

See examples of how to enter the cell ranges (the table_array argument) in VLOOKUP and HLOOKUP functions.