View Single Post
  #2   Report Post  
Old December 30th 20, 10:10 AM posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,832
Default Compare two Columns , and if is it a Match , copy


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

1.for each my cell in myRng1( myRng1 is BT1:BT200 ) with each my cell from myRng2 ( myRng2 is
BD11:BD42000 )
3.IF it is a match , Then , copy ,, 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.

Claus B.
Office 2016