Where to find vlookup function

The Related Lookup Table name. The field column in the Related Lookup Table that has the data you want in your new column. This information is not shown in the Manage Relationships dialog - you'll have to look at the Related Lookup Table to see which field you want to retrieve. The formula could also use a cell reference and a range reference. Continue adding fields until you have all the fields that you need. If you are trying to prepare a workbook containing data features that use multiple tables, change the data source of the data feature to the new table.

If the first column isn't sorted, the return value might be something you don't expect. For more information on resolving REF! The NAME? To look up a person's name, make sure you use quotes around the name in the formula.

Using absolute references allows you to fill-down a formula so that it always looks at the same exact lookup range. Learn how to use absolute cell references. A question mark matches any single character.

This parameter determines whether you are looking for an exact match or approximate match. A parameter of TRUE means that a "close" match will be returned.

To find an approximate match, use TRUE as the final parameter. Let's lookup a value that does not exist in our data to demonstrate the importance of this parameter! If no match is found, it returns the next smaller value which in this case is "Apples". Let's modify our example above and assume that the table is in a different Sheet called Sheet2 in the range A1:B6. By preceding the table range with the sheet name and an exclamation mark, we can update our VLOOKUP to reference a table on another sheet.

Let's throw in one more complication. What happens if your sheet name contains spaces? If there are spaces in the sheet name, you will need to change the formula further. Let's assume that the table is on a Sheet called "Test Sheet" in the range A1:B6, now we need to wrap the Sheet name in single quotes as follows:. Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions.

Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. If you know the name of a product, for instance, and you want to quickly determine its price, simply enter the product name into Excel and VLOOKUP will find the price for you. Specify the cell in which you will enter the value whose data you're looking for.

In this case, we've selected the entire table excluding the headers.