Reply to thread

Message: [QUOTE="Montu, post: 3739885"] 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) [/QUOTE]