eramirez148
Board Regular
- Joined
- Aug 17, 2022
- Messages
- 54
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
- MacOS
Is there a way to use a formula in column C that will generate results from column F for the matching dates only for the active rows (Column B) if a row is inactive (Column B) the the results should be an empty cell.
A | B | C | D | E | F |
pos_date | Status | Results | |||
1/1/2021 | inactive | Look up list | |||
1/2/2021 | inactive | pos_date | list | ||
1/3/2021 | inactive | 1/1/2021 | A | ||
1/4/2021 | inactive | 1/2/2021 | B | ||
1/5/2021 | inactive | 1/3/2021 | C | ||
1/6/2021 | inactive | 1/4/2021 | D | ||
1/7/2021 | inactive | 1/5/2021 | E | ||
1/8/2021 | inactive | 1/6/2021 | F | ||
1/9/2021 | inactive | ||||
1/10/2021 | inactive | ||||
1/11/2021 | inactive | ||||
1/12/2021 | active | ||||
1/13/2021 | active | ||||
1/14/2021 | active |