I copied that into S9:S4635 but all I get is "#N/A"


Excelenator Wrote:
Have a look at this formula that you should place in column "S" of th
NSN LIST REF.

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

--
Optitro
-----------------------------------------------------------------------
Optitron's Profile: http://www.excelforum.com/member.php...fo&userid=2672
View this thread: http://www.excelforum.com/showthread.php?threadid=56742