1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| i = ThisWorkbook.Worksheets("data").Range("F2").End(xlDown).Row
j = Worksheets("canal").Range("B2").End(xlDown).Row
Set RangeNPRNOM = ThisWorkbook.Worksheets("canal").Range("A2: A" & j)
Set RangeNOM = Worksheets("canal").Range("D2: D" & j)
'ThisWorkbook.Worksheets("data").Range("U2").Formula = "=IF(IsError(Match(I2, [RangeNPRNOM], 0)), Index([RangeNPRNOM], Match(Data!K2, [RangeNOM], 0), 1), I2)"
'ThisWorkbook.Worksheets("data").Range("U2").Formula = "=IF(ISERROR(MATCH(I2,Worksheets("canal").Range("A2:A"&j),0)),INDEX(Worksheets("canal").Range("A2:A"&j),MATCH(data!K2,Worksheets("canal").Range("D2:D"&j),0),1),I2)"
Range("U2").AutoFill Destination:=Range("U2: U" & i) |
Partager