Vlookup issue

[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

 

[RagDyeR]

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