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 Jeovany. I tried both options but cannot get it to work

Answer 3

It might help if you made a copy of the worksheet available through Google Drive, Dropbox or OneDrive. Remove sensitive/proprietary information from the copy.

Answer 4

enter the following formula in I43 and copy down and across

I43:=IF(LEFT(TEXT($G43,"mmm"),3)=LEFT(I$4,3),"REMOTE","")

Answer 5

Hi Hans, ok, i have hopefully managed to do that here. Thanks for your help

https://www.dropbox.com/sh/qk9n2dssd90k1hd/AAAXogW0n2-CsM7cRkEHvCkva?dl=0