To match data of similar coding

Originally Posted by contaminated

Try this code

=INDEX(DATABANK!$D$2:$D$31,MATCH(1,INDEX(($A4=DATABANK!$A$2:$A$31)*(LIST!$B4=DATABANK!$B$2:$B$31),0),0))

PS: DATABANK sheet D10 is Manager....

After enter above formula firstly result show correctly, but after copy paste remaining cell all column show #NA. We once again attach file (sheet1 & sheet2) refer to easy what we do & what is correct or incorrect.