Google Sheets formula related to automation

[hj121479]

Hi,

I'm trying to pull screenshot #1 Jonathan's vacation date (column M-P; this is brought in from Column C-D) to screenshot #2 chart (for example, column AX-BA). I would like to have those dates automatically pulled into the screenshot #2 chart with the term used in screenshot#1 Column E (e.g., Vacation).

Could you please help me with the formula? Also, instead of naming it as Vacation (directly pulled from Screenshot #1 Column E), is there a way we can change it to V? For example, if Vacation, then V; if Holiday, then H, etc.

Thank you in advance!

#1.

#2.

 

[Fluff]

Please stop referring to Excel in your titles when you are not using Excel.

 

[Fluff]

Duplicate to: Excel Automation

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.