Excel is screwy

[Aardvark]

I have a Vlookup, works fine on absolutely everything except for one aspect.
I have a Vlookup table which returns the latest animal born in a zoo (I
create these things to keep me amused), it works fine for every entry except
one (belfast). wierdly though if I copy "belfast" from the lookup table and
paste it as the lookup value it works fine....but not if I type it.

Anyone else met this problem?

thanks,

Danny

 

[J.E. McGimpsey]

Do you have leading or trailing spaces in your lookup table?

 

[Aardvark]

nope

Do you have leading or trailing spaces in your lookup table?

 

[A.W.J. Ales]

Weird try (on a weird problem)
Have you tried "retyping" belfast in your lookup table.
I have had in the past more or less same problem and found that retyping the
entry sometimes "solves" the problem.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Martin]

There is a known error in some versions of Excel that scramble that
particular ascii sequence if entered from a keyboard. I believe it
been fixed in Excel XP.

 

[dizzykid]

Try retyping 'belfast' in both the lookup value and the lookup table and see
what happens. I would guess there's something weird in the table.

 

[Aardvark]

Thanks all,

I will try it when I return to work after the break.

Danny