| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare two Columns , and if is it a Match , copy
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare cells and copy columns after match | Excel Worksheet Functions | |||
| Compare Col A and Col M, if Match, Copy Col N to Col E | Excel Programming | |||
| Compare Col A and Col M, if Match, Copy Col N to Col E | Excel Worksheet Functions | |||
| Compare columns in two WBks and when match is found... | Excel Programming | |||
| Compare columns, delete the rows that DO match. | Excel Programming | |||
Threaded Mode
