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

I would guess it is a simple fix, and I would also guess that if you are not familiar with arrays they are NOT easier. They are DEFINITELY faster though.
It seems that a vlookup on a reference table for 15 items and IF the lookup returns a value then replace whatever needs to be replaced, otherwise next... but I cant help much without specifics.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

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

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.

If I were coding this, I'd use Find rather than a Filter.

Outer loop of search terms
Inner loop of Find to deal with duplicate entries


But looping through cells, 60,000 rows NO

An even cheesier way to deal with this would be to put new lines of the Product and Type at the top of the page so that any other VLOOKUPS in the sheet would catch those and miss the bad info below.

I meant NO coding, and just manual filter 15 times to keep it simple.

Looping through 60,000 cells ONCE is not that big of a deal, although it is NOT optimal. Arrays when you don't understand them are worse than looping 60k times, as silly as that seems.

Yeah I think the VLOOKUP method is likely the easiest. Filter on all 15 at once, then apply the vlookup to a premade reference table. Copy and paste values then never think about it again.

Another simple option is to create ONE lookup table where you map EVERYTHING and replace the entire problematic column with the simple vlookup. You will know it is all fixed and you can even have the formula error out when something new comes in so you can add it to the table.