Hello, I'm needing help creating a syntax for the following scenario. I have two sheets in an Excel file. I'm wanting to take column A from Sheet2 and see if there are any matches in column B of Sheet1, then if there is a match(or same containing character sequence) then return value "retired" to column H on Sheet1. If there is no match then just leave it blank. Thanks.
