vlookup

  • Thread starter Thread starter newkid47
  • Start date Start date
N

newkid47

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?
 
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.
 
Back
Top