Trying to figure out why my VLOOKUP won't work in my IF statement, highlighted in RED
Set mycell = myworksheet.Range("AK" & i) 'Contains Unit of Measure
Set mycell2 = myworksheet.Range("AD" & i) 'Contains UN/ID#
Set mycell3 = myworksheet.Range("B" & i) 'Contains static part #
If...