Example formulas (1):
Code:
=IF(ISBLANK('[B]G1-1[/B]'!$BB$1),"",'[B]G1-1'[/B]!$BB$1)
Code:
=IF(ISBLANK('[B]G1-1[/B]'!$BP$1),"",IF('[B]G1-1[/B]'!$BC$1=-1,"",'[B]G1-1'[/B]!$BP$1))Example formulas (2):
Code:
=IF(ISBLANK('[B]G2-2[/B]'!$BB$1),"",'[B]G2-2[/B]'!$BB$1)
Code:
=IF(ISBLANK([B]'G2-2[/B]'!$BP$1),"",IF('[B]G2-2[/B]'!$BC$1=-1,"",'[B]G2-2[/B]'!$BP$1))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.
| Sheet: 'Config' | Col A | Col B |
| Row 11 | G2-1 | No |
| Row 12 | G1-1 | No |
| Row 13 | G2-2 | Yes |
| Row 14 | G1-3 | Yes |
| Row 15 | G2-4 | No |
| Row 16 | G2-5 | No |
| Row 17 | G2-6 | Yes |
| Row 18 | G2-7 | Yes |
| Row 19 | G2-8 | Yes |
| Row 20 | G2-3 | No |
| Row 21 | G2-9 | Yes |
| Row 22 | G1-4 | No |
| Row 23 | G1-5 | No |
| Row 24 | G1-6 | No |
| Row 25 | G1-7 | No |
| Row 26 | G1-2 | No |
| Row 27 | G1-8 | No |
| Row 28 | G1-9 | No |
| Row 29 | G1-10 | Yes |
| Row 30 | G2-10 |
<tbody>
</tbody>
Also posted here.
Last edited:
