if cell contains specific text then change value of another cell

[Jovan Yong]

Hi guys, i need some help here.
As you can see from my excel from Cell C there is an identity " ct2 or ct3"
And from Cell B , there is a list of statement

Example :
"select qc_m, Version_n from v_vos_qc_ct2 where QC_M in ('PQC705');"

i would want the Cell C information to overwrite the one i bold in Cell B.
Is there a way to do that?

[Rekragisao]

Jovan,

There were no macro's found in your sheet, so I'm guessing the information is put in manually.

Use the following code to get what you want. This replaces your =replace code, which seems to be more used as the concentrate code shown below.

Please Login or Register  to view this content.

[Jovan Yong]

Jovan,

There were no macro's found in your sheet, so I'm guessing the information is put in manually.

Use the following code to get what you want. This replaces your =replace code, which seems to be more used as the concentrate code shown below.

Please Login or Register  to view this content.

Hi Rekragisao,
They tell me i have error in the code.

[Rekragisao]

Hi Rekragisao,
They tell me i have error in the code.

Jovan,

Please provide the given error, most likely its the way the code is divided. try using , instead of ;

[Jovan Yong]

They just give me a pop up saying there is a problem with the formula

[Rekragisao]

Jovan,

Please elaborate more, providing aid is difficult when there is very little information to go on.

Make sure that all the spacing's (; in my code) are set to your excels standard (either ; or ,). you can check this by seeing if after every spacing the code shifts from text1 to text2 etc. Otherwise paste the code in there, bypass the error and evaluate the code. Excel will then show you where the error occurs.

The code works fine for me so it should be an issue with preferences.

[Jovan Yong]

Thanks! Yup, i change to , and it works.