Excel is screwy

  • Thread starter Thread starter Aardvark
  • Start date Start date
A

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
 
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 *
 
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.
 
Aardvark said:
nope :(
Click to expand...

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?
 
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.
 
Back
Top