LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Index Match function for multiple linked variables Bob Excel Worksheet Functions 13 November 23rd 05 12:56 AM
Index Match function for multiple linked variables Bob Excel Worksheet Functions 0 November 22nd 05 02:12 AM
Match Function arguments Stan Altshuller Excel Worksheet Functions 3 March 11th 05 08:48 PM
VLOOKUP Function using multiple worksheets Fiona Excel Discussion (Misc queries) 0 March 10th 05 05:24 AM
Multiple Worksheets and Print Merge function pfe Excel Discussion (Misc queries) 2 December 2nd 04 11:23 PM


All times are GMT +1. The time now is 09:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"