Find and replace based on adjacent cells?

Hey guys,

I'm wondering whether or not this is possible...

I'm sifting through ENORMOUS spreadsheets worth of data and having to manually change all the records. It would be massively helpful if it were possible to replace values based on the adjacent cell's value.

Let me illustrate the issue...

\1

Lets say for every value in column B that says "CAMRY" I want to replace the cell next to in in column C to "WAGON". And for every value in column B that says "HILUX", I want to replace the value in column C to "UTILITY".

Is this style of finding and replacing possible at all without an add-in? Or with an add-in?

I'm sure this is possible - its just that my knowledge of Excel is somewhat limited.

Cheers.