#Vlookup excel how to#
#Vlookup excel download#

It's simpler than it sounds: The first column in the range is 1, the second column is 2, etc.

The third argument is the column index number. The value that it returns (in this case, the price) will always need to be to the right of that column. In this example, it will search column A for 'Photo frame'. It's important to know that VLOOKUP will always search the first column in this range. As with any function, you'll need to use a comma to separate each argument: 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.

#Vlookup excel 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.

#Vlookup excel download#

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