__:__

Example formulas (1)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: