Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index Match function for multiple linked variables | Excel Worksheet Functions | |||
Index Match function for multiple linked variables | Excel Worksheet Functions | |||
Match Function arguments | Excel Worksheet Functions | |||
VLOOKUP Function using multiple worksheets | Excel Discussion (Misc queries) | |||
Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) |