Make sure the cell the formula is placed in is NOT formatted as Text. Change
the format to "General" and then re-commit the formula (press F2 then Enter).

HTH
Elkar


"tutink777" wrote:

I am trying to pull addresses from a master address worksheet into columns on
another worksheet. The A2 column is sorted alpha, as is the first "matching
column" on the Full Addresses worksheet. I want to pull column 3, and I want
exact matches. I am pretty sure the formula is correct, but the worksheet
only shows the formula, not my result. I do not have the ctrl +` on, it just
will not show what I want it to pull, or even #N/A for a false result. What
am I missing? Thanks!

=vlookup(A2,'Full Address List(4-20-09)'!A1:J187,3,FALSE)