Formula help - reference data from 2nd sheet, with conditions
I’m looking for help with a formula for my sheet. Images of my sheets are below
Goal: I want to auto-populate the Holiday column in Sheet 1 with data from Sheet 2, based on certain conditions.
- Populate Sheet 1 Holiday column with data from Sheet 2 Holiday column, only if:
- Sheet 1 Date matches Sheet 2 Date, AND
- Sheet 2 has an X in it
- If Sheet 2 does NOT have an X, then the Sheet 1 Holiday column would stay blank.
Sheet 1 – This sheet has nested rows for each brand, so I think I’ll have to use a slightly different formula for each brand’s group of child rows.
Thank you for any help!!