Find and replace based on adjacent cells?

[Leo328i6]

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.

[canapone]

Hi,

you could try:

=IF(B2="CAMRY","WAGON",IF(B2="HILUX","UTILITY",B2))

and then copy the results in column B with paste special values.

Hope it helps.

Regards

[MSaylor]

=IF(B2="CAMRY","WAGON",IF(B2="HILUX","UTILITY",B2))

This would only work as long as you checked only the CAMRY & HILUX values. Once the formula finds any value other than these two, it will return a 0 value. You would need to nest your "IF" functions for as many values as you wanted to test for. If you had a number of values you were checking, your IF statement could get to be quite long.

You would want to place this formula in the destination cell. In the example you gave that would be C1 and then copy it down the column. I hope this helps.

[arthurbr]

Hi Leo and welcome to the board

Posting an example is always a good idea, and to make it easier for other members it would be better to post a sample sheet to work on. You can attach a sample the same way you attached the image.

I want to replace the value in column C to "UTILITY"

In your question you state you want to replace an existing value in col C by another.
Which would the original content be ?