Vlookup issue

  • Thread starter Thread starter Ciar?n
  • Start date Start date
C

Ciar?n

Has anyone any ideas on this???

I've got a vlookup that uses a text field (although the field actually
contains numbers) as its lookup_value.
When I enter the formula #n/a is returned, but if i place the cursor
in the lookup_value cell and hit enter the correct result is returned.
I've checked and there are no spaces at the end of the field???

Regards,
Ciarán
 
Your data doesn't match, as to the list being text and the lookupvalue being
a number, or vice-versa.

You could try something like this, to perform an auto convert on the lookup
value:

=VLOOKUP(--A1,B1:C10,2,0)

Note the minus signs before the A1.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Has anyone any ideas on this???

I've got a vlookup that uses a text field (although the field actually
contains numbers) as its lookup_value.
When I enter the formula #n/a is returned, but if i place the cursor
in the lookup_value cell and hit enter the correct result is returned.
I've checked and there are no spaces at the end of the field???

Regards,
Ciarán
 
Back
Top