Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
| docs:microsoft_office:excel:vlookup [2013/12/02 09:38] – billh | docs:microsoft_office:excel:vlookup [2015/05/04 10:11] (current) – [Tips] billh | ||
|---|---|---|---|
| Line 17: | 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:// | ||