Looping 'find' to find a value and replace a value in an adjacent column

Originally Posted by mikerickson

It sounds like this is a one time problem.
Excel's FIND should find each of the Products and then you can manually change their types.
Or perhaps AUTO-Filter

Yeah except it seems the OP wants to not find and replace, but find then replace TWO columns to the right.
So OP COULD filter on each of the 15, and just copy and paste over whatever is in the cells that need to be corrected.

I would likely do that instead of creating code, but looping through with a CASE statement also wouldnt be very difficult IF you wanted to learn in VBA or IF you had to do this multiple times in the future.