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,"

?


On 16 Kwi, 10:25, Mike wrote:
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,I F($B$2:$R$2=$D$6,IF($B$4:*$R$4=$A$3,1)),0))

Thanks

M

--
Mike
------------------------------------------------------------------------
Mike's Profile:http://www.thecodecage.com/forumz/member.php?userid=236
View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=86730