Вы можете сделать это с VBA, что-то вроде этого -
Sub test() Dim ws1 As Worksheet Dim ws2 As Worksheet 'rename sheet1 to point to the data you want to change and 'ws2 to the sheets you're looking up from Set ws1 = Worksheets("Sheet1") Set ws2 = Worksheets("Sheet2") Dim rngsearch As Range Dim rngfnd As Range 'These point to the SKU columns, change as needed Set rngsearch = ws2.Range("A:A") Set rngfnd = ws1.Range("A:A") Dim c As Range Dim d As Range For Each c In rngsearch If c <> "" Then For Each d In rngfnd If d = c Then 'this assumes SKU in A and target in U d.Offset(20) = "Not Visibility Individually" End If Next End If Next End Sub
Если sku появляется более одного раза, он найдет и их.
Проверьте это на копии ваших данных.