Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Named Range within an Array Formula | Excel Discussion (Misc queries) | |||
count(if(... using array formula: can I use a named range in my ca | Excel Worksheet Functions | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
Named range into an array | Excel Worksheet Functions | |||
Possible to reference column of named range in array formula? | Excel Programming |