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 [2013/11/04 11:23] – 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 16: | Line 17: | ||
| * if you are having trouble getting results and your common identifier is a number, make sure that values in both tables are actually numbers | * 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 one or more cells to a number | * 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 one or more cells to a number | ||
| - | * search Excel help for " | + | * [[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:// | ||