vlookup
 

I have 2 columns and wish to retrive the info from the 2nd column. If I type
the name from the 1st column I get #N/A, if I copy directly from the 1st
column I get the correct answer, my formula is
=VLOOKUP(C2,$A$2:$B$180,2,FALSE) Why can I not get the info when I type it in?

vlookup
 

Why can I not get the info when I type it in?

Because what you're typing doesn't match what's in the column. There may be
unseen whitespace characters in the column and you're probably not typing
those in. When you copy from the column you're copying those whitespace
characters so there's a match.

Look for leading/trailing whitespace characters in A2:A180.

--
Biff
Microsoft Excel MVP


"newkid47" wrote in message
...
I have 2 columns and wish to retrive the info from the 2nd column. If I
type
the name from the 1st column I get #N/A, if I copy directly from the 1st
column I get the correct answer, my formula is
=VLOOKUP(C2,$A$2:$B$180,2,FALSE) Why can I not get the info when I type it
in?