Hi,

Am Tue, 29 Dec 2020 11:47:33 -0800 (PST) schrieb Xxer Xxes:

1.for each my cell in myRng1( myRng1 is BT1:BT200 )
2.compare with each my cell from myRng2 ( myRng2 is
BD11:BD42000 )
3.IF it is a match , Then , copy ,, Range.my cell from myRng2.Offset(0, 7) untill,,(:)"
my cell from myRng2.Offset(0, 9) ,,
4. Destination (of the copy) : my cell from myRng1.Offset(0, 3)

try in BW1:
=IFERROR(INDEX($BK$11:$BM$42000,MATCH(BT1,$BD$11:$ BD$42000,0),0),"")
and copy down.


Regards
Claus B.
--
Windows10
Office 2016