Pe vineri, 1 ianuarie 2021, la 11:04:27 UTC+2, Claus Busch a scris:
Hi,

and copy the formula to BY1 and then down.

It work perfectly perfectly , as I wish you
the Year ,
Sir .

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 .