Hi Carim,
Since I got full support from you for "find number in a data base" on
previous day, therefore I need your help again for the same problem. Last
time I was finding solultion for match 1 data with another data, but this
time I have to match 1 data with two another data. Suppose Sheet 1 is
Application Data, Sheet 2 is Accepted Data & sheet 3 is Rejected Data. Now I
want to match Application Data with Accepted & Rejected data. So I have used
a formula in b2 of Application data sheet as below
=if(isna(match(a1,Accepted,0)),"Rejected",if(isna( match(a1,Rejected,0)),"Accepted",""))
but result shows "Rejected", though a1 number is not find by physically
checked. As per formula it should be show as blank, I don't know where is
wrong in my formula. Please help me.
Note - Accept = reference name of Accepted Data (A1:A200)
Reject = reference name of Rejected Data (A1:A32)

"Carim" wrote:

Hi,

Following formula does work for both Texts and Numbers :

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

HTH