View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Find number within two data base

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
---