index indirect match tab names

[Peterfc2]

=INDEX('2013-14'!$I$7:$I$100,MATCH($A$2,'2013-14'!$B$7:$B$100,0))

Tabs are named 2013-14, 2012-13 etc. down column B.

Whats the correct way of using indirect so I can fill down with the tab names please?

 

[Marcelo Branco]

Assuming the tab name in B1 maybe something like this

=INDEX(INDIRECT("'"&B1&"'!I7:I1000"),MATCH($A$2,INDIRECT("'"&B1&"'!B7:B1000"),0))

Hope this helps

M.

 

[Peterfc2]

Spot on and really quick response cheers