Forum Discussion

DennisMetro's avatar
DennisMetro
Brass Contributor
Jul 02, 2021
Solved

Excel formula

1.      =IF((C10="")*(D10=""),"",IF(C10>D10,$B$10,$E$10)) this formula correctly fills G16 with either B10 or E10 data. 2.     G17 contains a graphic which is linked to a named range and which works...
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 05, 2021

    DennisMetro 

    You may add named formulas for each cell with flag, e.g. for L17

    =XLOOKUP('Linked Picture'!$L$16, 'Linked Picture'!$Z$31:$Z$46, 'Linked Picture'!$AA$31:$AA$46,'Linked Picture'!$AA$47)

    and for O17

    =XLOOKUP('Linked Picture'!$O$16, 'Linked Picture'!$Z$31:$Z$46, 'Linked Picture'!$AA$31:$AA$46,'Linked Picture'!$AA$47)

Resources