VlookUp Help Please!

  • Thread starter Thread starter tutink777
  • Start date Start date
T

tutink777

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)
 
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
 
Thank you. It wasn't formatted as text, but a Social security number, and
that was the problem. Thanks. I am usually good at excel, but that had me
in fits. Thank you both very much.
 
Back
Top