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
|