Use text in cells to fill references to sheets in formulas

[CV12]

Hi,

Given the formula:

=MINIFS(EXPORT4!I:I,EXPORT4!C:C,">="&MINIFS(EXPORT1!E:E,EXPORT1!A:A,B3),EXPORT4!C:C,"<="&MAXIFS(EXPORT1!E:E,EXPORT1!A:A,B3))

The 'EXPORT1!' and 'EXPORT4!' refer to other sheets and are manually inserted. I would like to fill them in based on text in a cell.

For example:

Text in A1 is : 'EXPORT1!'. Whenever i change this to 'EXPORT2!' it should be changed correctly in the given formula.

Thanks in advance!

 

[gaz_chops]

Try

=MINIFS(EXPORT4!I:I,EXPORT4!C:C,">="&MINIFS(INDIRECT($A$1&"!E:E"),INDIRECT($A$1&"!A:A"),B3),EXPORT4!C:C,"<="&MAXIFS(INDIRECT($A$1&"!E:E"),INDIRECT($A$1&"!A:A"),B3))

 

[CV12]

Thanks

 

[gaz_chops]

You're welcome.