function indirect

  1. B

    Indirect Function advanced

    I am using this function, with B2 containig sheet name, C21 is the cell i am refering to with sheet name in B2. =INDIRECT("'"&$B$2&"'!C21") works fine! But: i want to copy down / copy right this with a chaning C21 (C22, C23, ...; D21, E21, ... respective) Since C21 is indicated as...

Some videos you may like

This Week's Hot Topics