Help Me please - Excel Lookup function returning results N/A

  • Thread starter Thread starter twoodard2
  • Start date Start date
T

twoodard2

I am using the following formula and for some reason on 3 records I get
the #N/A result, but I can't figure out what is wrong since the formula
works just fine on all the other records.

For example on one worksheet I have data consisting of the following
columns and what the column label is on a separate worksheet (I have
named the cell ranges in these 2 columns, cocode and coname
respectively:

(A)CODE, (B)COMPANY NAME

On the worksheet that I'm using the Lookup function on, I am using the
following formula to pull the code associated with the company.

=lookup(A2,coname,cocode)

I attempted to troubleshoot by evaluating the error and I cannot find
any reference that is out of place, wrong arrays, etc, nor is the data
being looked up been moved or altered. Any ideas for something I may
be missing here?

Thanks in advance for your help - I tried to attach the file, but it is
too large.
 
Hi
try
=VLOOKUP(A2,'sheet1'!$A$1:$B$1000,2,0)
if this also returns #NA the values are NOT identical 8maybe a
formating issue, spaces, etc.)
 
Back
Top