Example formulas (1):
Example formulas (2):
The formulas, as you can see, just display cell values from other sheets, and remain blank if corresponding cell formulas have no value. I need to incorporate another variable and qualifying column, seen below.
i.e. IF Column B (i.e. 'Config'!B:B) is YES of the corresponding value in Column A (i.e. 'Config'!A11:A30), (G1-1, G2-2, G1-3, etc.) then it's TRUE and I need to display the formula value above normally in each cell. IF Column B is NO of the corresponding value in Column A, then do NOT want to display formula value.
Formulas (1):
In this case the sheet code is (G1-1), which matches cell 'A12' and corresponding Column 'B12' = No, so NONE of the values from the formulas (1) above will display. All cells remain blank.
Formulas (2):
In this case the sheet code is (G2-2), which matches cell 'A13' and corresponding Column 'B13' = Yes, so ALL of the values from the formulas (2) above display normally.
[TABLE="align: left, border: 1, cellpadding: 0, cellspacing: 0"]
[TD="width: 64"]Sheet: 'Config'[/TD]
[TD="width: 64"]Col A[/TD]
[TD="width: 64"]Col B[/TD]
Row 11
[/td]G2-1
[/td]No
[/td]Row 12
[/td]G1-1
[/td]No
[/td]Row 13
[/td]G2-2
[/td]Yes
[/td]Row 14
[/td]G1-3
[/td]Yes
[/td]Row 15
[/td]G2-4
[/td]No
[/td]Row 16
[/td]G2-5
[/td]No
[/td]Row 17
[/td]G2-6
[/td]Yes
[/td]Row 18
[/td]G2-7
[/td]Yes
[/td]Row 19
[/td]G2-8
[/td]Yes
[/td]Row 20
[/td]G2-3
[/td]No
[/td]Row 21
[/td]G2-9
[/td]Yes
[/td]Row 22
[/td]G1-4
[/td]No
[/td]Row 23
[/td]G1-5
[/td]No
[/td]Row 24
[/td]G1-6
[/td]No
[/td]Row 25
[/td]G1-7
[/td]No
[/td]Row 26
[/td]G1-2
[/td]No
[/td]Row 27
[/td]G1-8
[/td]No
[/td]Row 28
[/td]G1-9
[/td]No
[/td]Row 29
[/td]G1-10
[/td]Yes
[/td]Row 30
[/td]G2-10
[/td]Yes
[/td]
[/TABLE]