LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 173
Default Array formula[S] in named range[S]

Am looking for a multiple named-range solution that contains formulas in each
cell.

This is the range stored in a table on another worksheet [let's call it WSR]
that would be named TaxCalc1 ...
=-$H7*Tax1PHd =+Tax2Other =-($J7+$L7)*Tax3Mult
What should happen is when my lookup becomes "TaxCalc" & "1", the above
formulas drop from WSR into cells L7:N26 on the relevant worksheet [let's
call it WSC].

Accordingly, when my lookup becomes "TaxCalc" & "2", another set of cells
that are in the same source table on WSR, named of course TaxCalc2, which
have slightly different formulas, then drop into L7:N26 on WSC.

And so on with TaxCalc3, TaxCalc4, etc as required.
There will be at least half a dozen.

Keeping in mind that a named array range can contain constants....
1stQtr = Array("Jan", "Feb", "Mar")
2ndQtr = Array("Apr", "May", "Jun")

.... Am hoping that someone knows how to substitute the constants in the
above Qtr example for formulas.

I have tried and tried various methods/syntaxes to no avail, and am now
stumped enough to type all of this [!!].

Thanx in advance to anyone who can assist.
Regards,
- Mike




 
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
Using Named Range within an Array Formula Ivor Davies Excel Discussion (Misc queries) 2 August 25th 09 11:15 AM
count(if(... using array formula: can I use a named range in my ca katy Excel Worksheet Functions 1 January 15th 08 02:13 AM
Array as a "named range" - formula ok in cells, but error as "named range" tskogstrom Excel Discussion (Misc queries) 11 December 28th 06 04:44 PM
Named range into an array Frigster Excel Worksheet Functions 2 September 6th 06 07:08 PM
Possible to reference column of named range in array formula? Kel Good Excel Programming 4 November 15th 05 06:44 AM


All times are GMT +1. The time now is 12:33 AM.

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

About Us

"It's about Microsoft Excel"