OK that works. Now the problem is I either get "#N/A", "O", or nothing.
It gives me nothing when that tool has been ordered but now says
"RCV'D". It gives me "#N/A" when that tool hasn't been on 'ORDER' at
all. I would rather have either nothing or "O".


Excelenator Wrote:
Did you adjust the ranges in the formula to match your ranges?

=IF(AND(NOT(ISERROR(VLOOKUP(F*9*,ORDER!$N$*9*:$N$* 4635*,1,F
ALSE))),UPPER(VLOOKUP(F*9*,ORDER!$N$*9*:$AK$*4635* ,24,FALSE
))<"RCV'D"),"O","")


--
Optitron
------------------------------------------------------------------------
Optitron's Profile: http://www.excelforum.com/member.php...o&userid=26729
View this thread: http://www.excelforum.com/showthread...hreadid=567425