sirmixalot
New Member
- Joined
- Jan 15, 2016
- Messages
- 7
Guys, I have been breaking my head on this and can't think of a helper column idea for some reason. Please let me know if I can clarify anything further.
Goal: Fill in Template in Picture 2 (the yellow part) based on the following constraints
Obtain values from Column B such as "bm-gq3a" etc based on the 3 criteria below
Column A with header "#" (Match to 0 or 1 or 2 in Row 3 in picture #2)
Columns C-F = "Yes" AND Columns G-K = "Yes" for the same row.
Example output provided in picture #2.
PICTURE 1 : Source Data
Picture 2: Template to fill in. solution filled in.
For example:
O16 = bm-gq3a is there because:
1st criteria: the value in O3 matched to the value in cell A4
2nd criteria: Loganville being "Yes" in cell H4
3rd Crtieria: plan "bm" being "Yes" in D4
Similarly, S16 = bm-gq3b because of value of 1 in cell S4 matching value of 1 in cell A5
Goal: Fill in Template in Picture 2 (the yellow part) based on the following constraints
Obtain values from Column B such as "bm-gq3a" etc based on the 3 criteria below
Column A with header "#" (Match to 0 or 1 or 2 in Row 3 in picture #2)
Columns C-F = "Yes" AND Columns G-K = "Yes" for the same row.
Example output provided in picture #2.
PICTURE 1 : Source Data
Picture 2: Template to fill in. solution filled in.
For example:
O16 = bm-gq3a is there because:
1st criteria: the value in O3 matched to the value in cell A4
2nd criteria: Loganville being "Yes" in cell H4
3rd Crtieria: plan "bm" being "Yes" in D4
Similarly, S16 = bm-gq3b because of value of 1 in cell S4 matching value of 1 in cell A5