That looks good, how would i set it up if I have 6 stock code listings
on 6 seperate worksheets.

When I try this formula ....

=IF((OR(ISNA(MATCH(F4,Duct!$C$1:$C$5000,0)),ISNA(M ATCH(F4,Extra!$C$1:$C$5000,0)),ISNA(MATCH(F4,Fitti ngs!$C$1:$C$5000,0)),ISNA(MATCH(F4,Flex!$C$1:$C$50 00,0)),ISNA(MATCH(F4,Other!$C$1:$C$5000,0)),ISNA(M ATCH(F4,Silencer!$C$1:$C$5000,0)))),"POA","
")

It always returns the POA answer, even if one of the ISNA(Match
statements returns a false state.


--
PeterG
------------------------------------------------------------------------
PeterG's Profile: http://www.excelforum.com/member.php...o&userid=16485
View this thread: http://www.excelforum.com/showthread...hreadid=386727