finding and replacing multiple values

re read your question

1) is this column CAR ?

 CAR4 = B89877 etc...

2) you post another workbook (file)

I asked you for a worksheet (e.g. sheet 2)

3) when it should be banana (and when shouldu it be banana yellow) with the same number.

You better change the nummer of banana (yellow) in e.g. 32133