software

I know there is a way to get a sum of the all the values in, say, D4,
in all the worksheets of a workbook (=SUM('Janec'!D4)). I want to
apply this principle to the MATCH function.I am trying to set up a match function to search through a specific
range ($H$4:$H$84) in 12 worksheets (1 worksheet for each month). The
formula I am using is =MATCH(F4,'Janec'!$H$4:$H$84,) but it does not
work. Is there any way to do this?Try...

=MATCH(TRUE,COUNTIF(INDIRECT(TEXT(DATE(2005,ROW(IN DIRECT(quot;1:12quot;)),1),quot;mmm
quot;)amp;quot;!H4:H84quot;),F4)gt;0,0)

....confirmed with CONTROL SHIFT ENTER, not just ENTER.

Hope this helps!

In article .comgt;,wrote:

gt; I know there is a way to get a sum of the all the values in, say, D4,
gt; in all the worksheets of a workbook (=SUM('Janec'!D4)). I want to
gt; apply this principle to the MATCH function.
gt;
gt;
gt; I am trying to set up a match function to search through a specific
gt; range ($H$4:$H$84) in 12 worksheets (1 worksheet for each month). The
gt; formula I am using is =MATCH(F4,'Janec'!$H$4:$H$84,) but it does not
gt; work. Is there any way to do this?