How to populate a specific cell based on text in another cell

Question

Hi,

    I am trying to populate a calendar with specific text based on the text in another cell

For example, if G43 says May, i want to auto populate M43 with a specific word (in this example it is REMOTE)

Another example is if G48 says February then i want to populate J48 

Essentially, i am trying to create a visual Calendar / Planner

Answer 1

Thanks!

Change the formula in G5 on the Project Planner sheet to

='Full Details'!J2&""

Then fill sown to G55. This will remove those strange Jan-00 values.

Enter the following formula in I5:

=IF(LEFT($G5,3)=I$4,"REMOTE","")

Copy I5.

Select I5:T55.

Click the lower half of the Paste button and select Formulas.

See the modified version at https://www.dropbox.com/s/247adxepcefzrgi/JASON%20AUDIT%20PLANNER%20GRAPH%202021%20for%20help.xlsx?dl=1

Answer 2

Thanks for your suggestion. I couldn't manage to get that to work, i suspect its my formatting of cells though that is the problem

Answer 3

Hans that is so appreciated. You have solved my issue perfectly.

Thanks so much.