Using Indirect with an Index Match Function

[Mike]

I have a number of worksheets January - December which I wiish to
retrieve data from onto my Data worksheet using the INDEX MATCH
function. How do I include the INDIRECT function which will enable me to
enter the Month I require into a cell on my Data worksheet to return the
relavent information.

=INDEX($B$2:$R$47,MATCH($D,$A$2:$A$47,0),MATCH(1,IF($B$2:$R$2=$D$6,IF($B$4:$R$4=$A$3,1)),0))

Thanks

M

 

[Jacob Skaria]

A1 = SheetNAme
A2 = value

=INDIRECT(A1&"!" & "A2")

If this post helps click Yes

 

[Jarek Kujawa]

do you mean sth. like:

=INDIRECT(A1&"!$A$2:$A$47")

with A1=January
(or any other month)
adjust ranges to suit

aren't you lacking a cell address in yr 1st MATCH

"MATCH($D,"

?

 

[Mike]

Thanks for the help very much appreciated'

Mike.