Hi ,

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 .