Ok here goes:


Code:
--------------------
=IF(AND(NOT(ISERROR(VLOOKUP(F9,ORDER!$N$9:$N$4634, 1,FALSE))),IF(NOT(ISERROR(VLOOKUP(F9,ORDER!$N$9:$A K$4634,24,FALSE ))),UPPER(VLOOKUP(F9,ORDER!$N$9:$AK$4634,24,FALSE ))<"RCV'D",FALSE)),"O","")
--------------------


Optitron Wrote:
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


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