software

I am setting up a bank account project with 12 worksheets, one for each
month. I know that it is possible to find the sum of a specific cell
thoughout all of the worksheets (=SUM('Janec'!D4). I am trying to
apply this same principle to the MATCH function.

The formula I have put together is
=IF(ISBLANK(H8),quot;--quot;,IF(ISERROR(MATCH(ABS(H8),'Janec'!$F$4:$F$84,)) ,quot;NOquot;,MATCH(ABS(H8),'Janec'!$F$4:$F$84,))).
Every answer comes up as either a quot;--quot; or quot;NOquot;, though, when I know
that there happens to be a match right there in the same worksheet. Do
you see any obvious problems with this? Any advice?

ThanksYou can get an indicator if you add the sheet names Jan - Dec in C1:C12 and
use

=IF(ISBLANK(H8),quot;--quot;,IF(SUMPRODUCT(COUNTIF(INDIRECT(quot;'quot;amp;C1:C12amp;quot;'!F4: F24quot;),A
BS(H8)))=0,quot;NOquot;,quot;YESquot;))

What were you wanting exactly in a YES condition?

--

HTH

RP
(remove nothere from the email address if mailing direct)gt; wrote in message oups.com...
gt; I am setting up a bank account project with 12 worksheets, one for each
gt; month. I know that it is possible to find the sum of a specific cell
gt; thoughout all of the worksheets (=SUM('Janec'!D4). I am trying to
gt; apply this same principle to the MATCH function.
gt;
gt; The formula I have put together is
gt;
=IF(ISBLANK(H8),quot;--quot;,IF(ISERROR(MATCH(ABS(H8),'Janec'!$F$4:$F$84,)) ,quot;NOquot;,M
ATCH(ABS(H8),'Janec'!$F$4:$F$84,))).
gt; Every answer comes up as either a quot;--quot; or quot;NOquot;, though, when I know
gt; that there happens to be a match right there in the same worksheet. Do
gt; you see any obvious problems with this? Any advice?
gt;
gt; Thanks
gt;