MATCH function through multiple worksheets

P

patryan22

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
 
B

Bob Phillips

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)
 
Top