Index-Indirect-Match

[plateo2000]

In 2016 trying to substitute Indirect for manually entered sheet name (bold) in following:

=IFERROR(INDEX('FYE2015'!$D$4:$D$1322,MATCH('3DRev'!I$6,'FYE2015'!$B$4:$B$1322,0)),0)

I have a range of sheet names in column B (FYE2006 to FYE2017)

 

[cerfani]

In 2016 trying to substitute Indirect for manually entered sheet name (bold) in following:

=IFERROR(INDEX('FYE2015'!$D$4:$D$1322,MATCH('3DRev'!I$6,'FYE2015'!$B$4:$B$1322,0)),0)

I have a range of sheet names in column B (FYE2006 to FYE2017)

=INDIRECT("[COLOR=#333333]'"&[/COLOR][B]B2&"'!$D$4:$D$1322")[/B]

will evaluate to this...

[COLOR=#333333]'[/COLOR][B]FYE2015'!$D$4:$D$1322[/B]

assuming the sheetnames start at B2

 

[plateo2000]

Thanks, cerfani.