VlookUp Help Please!
 

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)

VlookUp Help Please!
 

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)

VlookUp Help Please!
 

Sounds like your formula column is formatted as text.

--
Regards
Rob
"tutink777" wrote in message
...
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)

VlookUp Help Please!
 

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.

"RobWN" wrote:

Sounds like your formula column is formatted as text.

--
Regards
Rob
"tutink777" wrote in message
...
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)