MATCH function through multiple worksheets
 

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('Jan:Dec'!D4). I am trying to
apply this same principle to the MATCH function.

The formula I have put together is
=IF(ISBLANK(H8),"--",IF(ISERROR(MATCH(ABS(H8),'Jan:Dec'!$F$4:$F$84,)) ,"NO",MATCH(ABS(H8),'Jan:Dec'!$F$4:$F$84,))).
Every answer comes up as either a "--" or "NO", 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?

Thanks

MATCH function through multiple worksheets
 

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

=IF(ISBLANK(H8),"--",IF(SUMPRODUCT(COUNTIF(INDIRECT("'"&C1:C12&"'!F4: F24"),A
BS(H8)))=0,"NO","YES"))

What were you wanting exactly in a YES condition?

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
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('Jan:Dec'!D4). I am trying to
apply this same principle to the MATCH function.

The formula I have put together is

=IF(ISBLANK(H8),"--",IF(ISERROR(MATCH(ABS(H8),'Jan:Dec'!$F$4:$F$84,)) ,"NO",M
ATCH(ABS(H8),'Jan:Dec'!$F$4:$F$84,))).
Every answer comes up as either a "--" or "NO", 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?

Thanks