Need to changed the value in a cell based on another cell with multiple values options

[Tacnola1]

I need aformula that will auto populate like this:
If A1 shows “M”,then auto populate in A2 “T”,

or “T” , “W”,

or “Th”, “F”,

and so on.

I was tryingto write an “IF” statement, and then a VLOOKUP, but I am not good at writingthese formulas. Could anyone assist in helping write this.

I havecreated a table in another sheet that has the values M, T, W, Th, F, Sa, Su Ifthat helps.
Thank you for your assistance.

 

[Tetra201]

Try

=LOOKUP(A1,{"F","M","Sa","Su","T","Th","W"},{"Sa","T","Su","M","W","F","Th"})

 

[Tacnola1]

Thank you so much. It appears to work as needed!!

 

[Tacnola1]

At first I thought it was working. But it is not. For some reason, once I get past the 2nd cell, it no longer producing the correct match.

 

[Tetra201]

Do you have calculations in your worksheet set to "Automatic"?

 

[Tacnola1]

Thank you for your help! After some adjustments. I was able to get it to work properly!