Excel 2007 : Replace Text Function

[jeliash]

I have spent along time trying to figure this out, perhaps someone can help me with this.

If the TEXT in cell A1 is the same as the TEXT found anywhere on Column B, then replace it with the TEXT that is on Column C (On the side of the corresponding cell in Column B.)

For example, if A1 is the same as B5, then replace A1 with C5.

I hope this makes sense, I had a function for this long time ago, but I can't remember, this is frustrating. :S

Any help is greatly appreciated, thank you!