View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Montu Montu is offline
external usenet poster
 
Posts: 50
Default find number in a data base

Thanks for your suggession, but the following formula is for matching between
two number or data. I need find or search a data into another whole database.
That means I want to search number or text of Sheet2 (Sheet2!b2) into sheet1
(Sheet!1b2:end of data within the column). If get the search or find number
from database (Sheet1) then result show "Accepted" ortherwise "Rejected". Is
there any formula for above problem. Suggest me.

"Carim" wrote:

Hi,

What about :
=IF(ISNA(MATCH(B2,Sheet2!B:B,0)),"Rejected","Accep ted")

HTH