vlookup formatting problem

[LORIB]

I'm attempting to run a v-lookup using data imported from another application
and I can't get the lookup to recognize the data. I've tried multiplying by
one and tried all types of copying and re-formatting but nothing seems to
work. Can anyone help me?

 

[Frank Kabel]

Hi
have you checked for invisible characters as well?. Test your values
character by charatcer

 

[Nick Hodge]

Don't take offence, I do it all the time but for example have you got a
single column lookup range with an offset greater than one, eg

=VLOOKUP(A1,$D$1:$D$100,2,FALSE)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[LORIB]

Thanks for your response Frank. How do I do that?

 

[LORIB]

good looking out, but no. any other ideas?

Don't take offence, I do it all the time but for example have you got a
single column lookup range with an offset greater than one, eg

=VLOOKUP(A1,$D$1:$D$100,2,FALSE)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Frank Kabel]

Hi
lets assume your value is in cell A then enter the following formula in
cell B1:
=CODE(MID($A$1,COLUMN(A:A),1))
and copy this to the right. this shows the ASCII codes for each
character. Compare this to your lookup value and check if they differ

 

[LORIB]

That was cool, but they don't differ. Any other suggestions?

 

[Frank Kabel]

Hi
the post your VLOOKUP formula which does not work and the values from
the lookup cell and the supposed matching cell