Find Data and Change A Different Column
 

I have two columns of data with about ~100 rows (plant names and type of
plant). This information comes from a dump file from a website.
Unfortunately the type of plant for 11 of the plants is not what I need it
to be so I need to change the dump file information to another type of plant.
For example, in the dump file plant #44 is listed as an electronics plant
but it is a technical center. I normally just manually change them but I
would like to automate this. How could I do this in VBA coding or by
formula if it is possible.

Any help would be appreciated.

Thanks.