HOW TO USE VLOOKUP IN EXCEL TABLE HOW TO

The second argument is the cell range that contains the data. Because the argument is text, we'll need to put it in double quotes: The first argument is the name of the item you're searching for, which in this case is Photo frame. The arguments will tell VLOOKUP what to search for and where to search. Our arguments will need to be in parentheses, so type an open parenthesis. As with any formula, you'll start with an equals sign (=). We'll add our formula to cell F2, but you can add it to any blank cell.

HOW TO USE VLOOKUP IN EXCEL TABLE HOW TO

Once you learn how to use VLOOKUP, you'll be able to use it with larger, more complex spreadsheets, and that's when it will become truly useful. You can probably already see that the price is $9.99, but that's because this is a simple example. We're going to use VLOOKUP to find the price of the Photo frame. For example, if you have a list of products with prices, you could search for the price of a specific item. What exactly is VLOOKUP?īasically, VLOOKUP lets you search for specific information in your spreadsheet.

You can download the example if you'd like to work along with this article. VLOOKUP works the same in all versions of Excel, and it even works in other spreadsheet applications like Google Sheets. Check out our Functions lesson from our Excel Formulas tutorial (or select a specific version of Excel). VLOOKUP is an extremely useful tool, and learning how to use it is easier than you think!īefore you start, you should understand the basics of functions.

Many of our learners have told us they want to learn how to use Excel's VLOOKUP function. en/excel-tips/a-trick-for-finding-inconsistent-data/content/ How to use Excel's VLOOKUP function Lesson 19: How to Use Excel's VLOOKUP Function

How to use vlookup in excel table