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.
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.
Last edited by a moderator: