Replacing Values based on Speicific Text

[SaadKiji]

Hi everyone,

I'm looking for a formula to replace cells value based on specific text, example:
Search A1 for "1" then replace A2 value to "F".

Thanks in Advance.Capture.PNG

[SaadKiji]

I did this simple formula: =IF(A1=1,"F","")

But I'm looking for more professional one.

[JohnTopley]

Use a "lookup" table containing numbers and the corresponding text. Or is the sample a simplified version of something more complex.

=VLOOKUP(D1,$A$1:$B$10,2,0)

See attached

[SaadKiji]

Thank you John,

Acutely, I need to replace B2 value if A2 equal to "1" with a new value "F".

[JohnTopley]

So how do we determine the new value?

[SaadKiji]

I have to specify it like "F".

[JohnTopley]

Then if you cannot have a table of values, then you will have to "hard-code" them as per your IF formula.