I am using the same as you, would it be the size of the range, as it goes
o.1,0.2,all the way to 28?
Every other sheet with lookup works fine but not this one
bob

"Roger Govier" wrote:

Hi Bob

What formula are you using?
=LOOKUP(4.5,A2:A5) returns 4.5 for me

--
Regards

Roger Govier


"Bob" wrote in message
...
Full Handicap Playing Handicap
4.3 4
4.4 4
4.5 5
4.6 5
Lookup will return 4 if i am looking for 4.4, and 5 if i look for 4.6.
But
for some reason on all the #.5 will always return with the wrong
result. For
eg 4.5 will return 4 not 5.
Any ideas