Hi,

Can someone help me to find out the cause of why vlookup works for some cells but not others although the formulae is the same as copied down ? Also, I've tried Index and Match and still the same problems occur on the same cells. I've checked on blank spaces and sorted table in the same way but still the same problem faced.

=VLOOKUP(A2&"|"&B2,CHOOSE({1,2},'[Sales Rep.xlsx]Sheet1'!$A$2:$A$2687&"|"&'[Sales Rep.xlsx]Sheet1'!$B$2:$B$631,'[Sales Rep.xlsx]Sheet1'!$C$2:$C$2687),2,0)


=INDEX('[Sales Rep.xlsx]Sheet1 (2)'!$D$2:$D$2687,MATCH(K2,'[Sales Rep.xlsx]Sheet1 (2)'!$C$1:$C$631,0))

Tks.