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 Wrote:
I copied that into S9:S4635 but all I get is "#N/A"


--
Excelenator


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