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.

 

[Harlan Grove]

nope

It's still far more likely than not that your problem is that 'belfast' in
the table and 'belfast' in the lookup value entry differ somehow. For the
heck of it, what are the results of LEN() applied to each when the VLOOKUP
function isn't working? Also, is it possible that 'belfast' in the lookup
table contains a numeral one (1) rather than a lower case L?

 

[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