Thread: find number in a data base
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default find number in a data base
Hi,

Following formula does work for both Texts and Numbers :

=IF(ISNA(MATCH(Sheet2!B2,Sheet1!B:B,0)),"Rejected" ,"Accepted")

HTH
Reply With QuoteReply With Quote