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

Tacnola1

New Member
Joined
Apr 24, 2019
Messages
9
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.



 

Tacnola1

New Member
Joined
Apr 24, 2019
Messages
9
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.
 

Tacnola1

New Member
Joined
Apr 24, 2019
Messages
9
Thank you for your help! After some adjustments. I was able to get it to work properly!
 

Forum statistics

Threads
1,084,753
Messages
5,379,664
Members
401,620
Latest member
Ankur Teotia

Some videos you may like

This Week's Hot Topics

Top