Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| docs:microsoft_office:excel:vlookup [2012/04/04 17:55] – billh | docs:microsoft_office:excel:vlookup [2015/05/04 10:11] (current) – [Tips] billh | ||
|---|---|---|---|
| Line 4: | Line 4: | ||
| **Example: | **Example: | ||
| < | < | ||
| - | =VLOOKUP(A3, | + | =IFERROR(VLOOKUP(A3, |
| </ | </ | ||
| + | * the VLOOKUP function is " | ||
| * A3 holds the common identifier (primary key) in table 1 | * A3 holds the common identifier (primary key) in table 1 | ||
| * Sheet1!A:B defines the table 2 area | * Sheet1!A:B defines the table 2 area | ||
| Line 14: | Line 15: | ||
| * table 2 must have the common identifier as the first column, although you don't have to select an entire sheet - you can define cells or columns within a sheet | * table 2 must have the common identifier as the first column, although you don't have to select an entire sheet - you can define cells or columns within a sheet | ||
| * if the identifier in table 2 isn't sorted, the last parameter of the vlookup function must be FALSE | * if the identifier in table 2 isn't sorted, the last parameter of the vlookup function must be FALSE | ||
| - | * if you are having trouble getting results and your common identifier is a number, make sure that values in both tables are actually numbers; search Excel help for "convert to number" | + | * if you are having trouble getting results and your common identifier is a number, make sure that values in both tables are actually numbers |
| + | * look for the green arrow in the upper left of a cell, and a yellow flag to the right; clicking on the yellow flag allows you to convert | ||
| + | * [[Convert Text to Number]] | ||
| * if you are comparing text, make sure you don't have odd characters in the strings, or empty space at the beginnings or ends; press F2 and examine a definite match carefully to find problems | * if you are comparing text, make sure you don't have odd characters in the strings, or empty space at the beginnings or ends; press F2 and examine a definite match carefully to find problems | ||
| ===== External Links ===== | ===== External Links ===== | ||
| * [[http:// | * [[http:// | ||