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

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.