I have 12000 data entry in sheet 1 like -
A B C D
Sl No. Application N0. Name Date of Birth
1 012510100052658 A.Mahato 18/10/1952
2 012510100052669 N.Nandi 28/09/1970
Continued to ..... Sl no. 12000.
I have another data whose application has been accepted in sheet 2 like -
Sl No. Application N0. Name Date of Birth
1 012510100012788 B.Biswas 01/07/1982
2 012510100043247 P.Paul 18/02/1962
Now I have to find out Rejected applicant from sheet 1, so I have use a
formula like
=if(index(Appl_No,match(b2,Accept_No,0),match($b$2 ,$2:$2,0)),"Accepted","Rejected")
Appl_No. = it's a reference of Sheet1 B2:B12001
Accept_No. = it's a reference of Sheet2 B2:end of data of the column.
the result shown as "#N/A", suggest me where is the wrong in my formula &
what is correct. Thanks in advance.