If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Indirect with an Index Match Function
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 |
#2
|
|||
|
|||
Using Indirect with an Index Match Function
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 |
#3
|
|||
|
|||
Using Indirect with an Index Match Function
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 |
#4
|
|||
|
|||
Using Indirect with an Index Match Function
Thanks for the help very much appreciated' Mike. working fine nowJacob Skaria;310257 Wrote: 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: 'The Code Cage Forums - View Profile: Mike' (http://www.thecodecage.com/forumz/member.php?userid=236) View this thread: 'Using Indirect with an Index Match Function - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=86730) -- 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 |
Thread Tools | |
Display Modes | |
|
|