Find number within two data base

M

Montu

Since I got full support from this forum 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,Accept,0)),"Rejected",if(isna(match(a1,Reject,0)),"Accepted",""))

but result shows "Rejected", though a1 number is not found in Accepted &
Rejected data sheet by physically checked (use ctrl+f). 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)
 
M

Max

One alternative to get it
=IF(ISNUMBER(MATCH(A1,Accept,0)),"Accepted",IF(ISNUMBER(MATCH(A1,Reject,0)),"Rejected",""))
 
M

Max

Think a better alternative to use is:
=IF(AND(ISNUMBER(MATCH(A1,Accept,0)),ISNUMBER(MATCH(A1,Reject,0))),"Check",IF(ISNUMBER(MATCH(A1,Accept,0)),"Accepted",IF(ISNUMBER(MATCH(A1,Reject,0)),"Rejected","")))

If A1 is somehow found in *both* Accept & Reject,
it'll alert you via returning: "Check"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top