Think a better alternative to use is:
=IF(AND(ISNUMBER(MATCH(A1,Accept,0)),ISNUMBER(MATC H(A1,Reject,0))),"Check",IF(ISNUMBER(MATCH(A1,Acce pt,0)),"Accepted",IF(ISNUMBER(MATCH(A1,Reject,0)), "Rejected","")))
If A1 is somehow found in *both* Accept & Reject,
it'll alert you via returning: "Check"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---