Compare two Columns , and if is it a Match , copy
try in BW1:
=IF(ISNA(MATCH($BT1,$BD$11:$BD$42000,0)),"",INDEX ($BK$11:$BM$42000,MATCH($BT1,$BD$11:$BD$42000,0), COLUMN(A1)))
and copy the formula to BY1 and then down.
for the formula above ,now I just have found it have
a miss in his task : formula, when find identical values ,
it bring the result from first number , repeting his values
from columns of BW to BY . If is not understable , I will
write here an exemple .