A1 = SheetNAme
A2 = value

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

If this post helps click Yes
---------------
Jacob Skaria


"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