LOOKUP - known bugs, glitches???

[SCW]

I've done a search on this site for known bugs, but got zero results...

Has anyone ran into the following???

I have copied and pasted the following formula into 4 cells:

AA2
=LOOKUP($Z2,LinealProjectOrder!$A$3:$A$463,LinealProjectOrder!$C$3:$C$463)

AA3
=LOOKUP($Z3,LinealProjectOrder!$A$3:$A$463,LinealProjectOrder!$C$3:$C$463)

AA4
=LOOKUP($Z4,LinealProjectOrder!$A$3:$A$463,LinealProjectOrder!$C$3:$C$463)

AA5
=LOOKUP($Z5,LinealProjectOrder!$A$3:$A$463,LinealProjectOrder!$C$3:$C$463)

Where the only difference between each of these is the reference to the
contents of Z2, Z3, Z4, and Z5 respectively...

However Cell AA4 gives me the results of AA5 no matter what I do. If I
manually subsitute any other value in place of Z4 within that 3rd cell
I get correct answers, yet not when the Value of Z4 is there.

Anyone heard of similar issues? Know of a solution? I'm running
Office XP Pro on XP pro with all the latest patches and updates.

Thanks in advance for any assistance.

Greg

 

[J.E. McGimpsey]

Are either Z4 or your table dervied from calculations? If so, the
number you think you're looking up may not be what's stored in the
cell. Lookup returns the next highest value if it can't find an
exact match, so if you're look-up table has the values 4, 5, 6.. and
Z4 =5.000001 (even though you may have it set to display 5.0),
LOOKUP() will return the value corresponding to 6.

One way to fix that would be to lookup ROUND($Z4,0) in that case.

 

[SCW]

Thanks for the feedback.

Yes the value in Z4 is derived (but not calculated) from another cell.
It's a cold hard solid integer (600), as the others are too.
Just for fun tho, I tried the round suggestion... still no luck. I
even tried using the same calc that drove the answer in Z4, same
results.

I've tried entering different values to see if it would affect it, but
nope!

I've also tried cutting and pasting these cells to a different location
- just to see if it was a cell thing. No luck.

I'm thinking it must be me, something that I'm missing. There's too
much psotive history behind Excel and these formulas - that I would
have read about, or that someone would have piped in by now - on any
known bugs/issues.

Any other things I should look for?

thx!!!

 

[SCW]

Weirdness...
Okay now I'am trying a whole new look up:

AA4
=VLOOKUP(LARGE(LinealProjectOrder!$A$3:$A$463,3),LinealProjectOrder!$A$3:$C$463,3,FALSE)

And all the other cells around it are using the same formula now too...
Yet I still get the same inaccurate results - only in this cell.

What the heck is going on here?

I've Changed the values/contents of the cells (along with the formula
now), and it gives incorrect results no matter what.

Help!

 

[SCW]

HA! I figured it out! My reference table was getting wacked while I
was fine tuning the work book.

All is fine now!

Thanks to those who contributed!!!!