is there a way to use an array or something similar to calculate a 3 variable
problem, so that different sheets can reference a formula on another sheet,
and come up with different values, without having multiple formulas?

something similar to 3D arrays?
i've been using the index function with 2 nested match functions, but that
only helps with 2 variables

Not enough detail

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
is there a way to use an array or something similar to calculate a 3
variable
problem, so that different sheets can reference a formula on another
sheet,
and come up with different values, without having multiple formulas?

something similar to 3D arrays?
i've been using the index function with 2 nested match functions, but that
only helps with 2 variables

sorry.
i have to do some thermal calculations with 3 variables:
system type (so a text)
window vision %,
and Glass COG ( another category)
so far, i've set up a chart on a data sheet with the x axis the COG, and y
axis a System type.
where those two meet, i'm i have a linear equation (y= mx + b), where y is
the thermal calc i need, and x is the window percent.

My problem lies where i need to 'call' that equation from the data sheet,
take it to a window frame sheet, and somehow imput a calculated % into the
linear equation.
these percents change, so i can't just plug it in to all the equations.

My question is: can i do that somehow? is it also possible to call a sheet
a variable, so that if the equation is successfully called, it will input a
percent that the sheet that called it has calculated?

Hopefully that's a little more detailed...

"T. Valko" wrote:

Not enough detail

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
is there a way to use an array or something similar to calculate a 3
variable
problem, so that different sheets can reference a formula on another
sheet,
and come up with different values, without having multiple formulas?

something similar to 3D arrays?
i've been using the index function with 2 nested match functions, but that
only helps with 2 variables

Sorry, I'm not following you on this.

If you have a 2 dimensional lookup table where does the 3rd variable come
into play?

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
sorry.
i have to do some thermal calculations with 3 variables:
system type (so a text)
window vision %,
and Glass COG ( another category)
so far, i've set up a chart on a data sheet with the x axis the COG, and y
axis a System type.
where those two meet, i'm i have a linear equation (y= mx + b), where y is
the thermal calc i need, and x is the window percent.

My problem lies where i need to 'call' that equation from the data sheet,
take it to a window frame sheet, and somehow imput a calculated % into the
linear equation.
these percents change, so i can't just plug it in to all the equations.

My question is: can i do that somehow? is it also possible to call a
sheet
a variable, so that if the equation is successfully called, it will input
a
percent that the sheet that called it has calculated?

Hopefully that's a little more detailed...

"T. Valko" wrote:

Not enough detail

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
is there a way to use an array or something similar to calculate a 3
variable
problem, so that different sheets can reference a formula on another
sheet,
and come up with different values, without having multiple formulas?

something similar to 3D arrays?
i've been using the index function with 2 nested match functions, but
that
only helps with 2 variables

the third variable comes into play in the table - for example:
with system 1, and a .30 COG, my index and match functions will call this:
0.014*F7 + 1.50
the F7 is my third variable - the percent vision. So, the 2 dimensional
lookup is not enough for what i need - i need a lookup which looks up the
equation, but than can plug in a value for the percent, depending on what
sheet is calling the equation in the first place - since the % vision is
calculated on another sheet, and changes in every new sheet.
Sorry that this is a little confusing... it's a complicated thing im trying.

"T. Valko" wrote:

Sorry, I'm not following you on this.

If you have a 2 dimensional lookup table where does the 3rd variable come
into play?

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
sorry.
i have to do some thermal calculations with 3 variables:
system type (so a text)
window vision %,
and Glass COG ( another category)
so far, i've set up a chart on a data sheet with the x axis the COG, and y
axis a System type.
where those two meet, i'm i have a linear equation (y= mx + b), where y is
the thermal calc i need, and x is the window percent.

My problem lies where i need to 'call' that equation from the data sheet,
take it to a window frame sheet, and somehow imput a calculated % into the
linear equation.
these percents change, so i can't just plug it in to all the equations.

My question is: can i do that somehow? is it also possible to call a
sheet
a variable, so that if the equation is successfully called, it will input
a
percent that the sheet that called it has calculated?

Hopefully that's a little more detailed...

"T. Valko" wrote:

Not enough detail

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
is there a way to use an array or something similar to calculate a 3
variable
problem, so that different sheets can reference a formula on another
sheet,
and come up with different values, without having multiple formulas?

something similar to 3D arrays?
i've been using the index function with 2 nested match functions, but
that
only helps with 2 variables

So, F7 is the result of the lookup and the equation that uses F7 depends on
what sheet is using the equation?

Can't you use an IF function? Of course, this would be limited to a certain
number of nested levels (depending on which version of Excel you're using).

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
the third variable comes into play in the table - for example:
with system 1, and a .30 COG, my index and match functions will call this:
0.014*F7 + 1.50
the F7 is my third variable - the percent vision. So, the 2 dimensional
lookup is not enough for what i need - i need a lookup which looks up the
equation, but than can plug in a value for the percent, depending on what
sheet is calling the equation in the first place - since the % vision is
calculated on another sheet, and changes in every new sheet.
Sorry that this is a little confusing... it's a complicated thing im
trying.

"T. Valko" wrote:

Sorry, I'm not following you on this.

If you have a 2 dimensional lookup table where does the 3rd variable come
into play?

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
sorry.
i have to do some thermal calculations with 3 variables:
system type (so a text)
window vision %,
and Glass COG ( another category)
so far, i've set up a chart on a data sheet with the x axis the COG,
and y
axis a System type.
where those two meet, i'm i have a linear equation (y= mx + b), where y
is
the thermal calc i need, and x is the window percent.

My problem lies where i need to 'call' that equation from the data
sheet,
take it to a window frame sheet, and somehow imput a calculated % into
the
linear equation.
these percents change, so i can't just plug it in to all the equations.

My question is: can i do that somehow? is it also possible to call a
sheet
a variable, so that if the equation is successfully called, it will
input
a
percent that the sheet that called it has calculated?

Hopefully that's a little more detailed...

"T. Valko" wrote:

Not enough detail

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
is there a way to use an array or something similar to calculate a 3
variable
problem, so that different sheets can reference a formula on another
sheet,
and come up with different values, without having multiple formulas?

something similar to 3D arrays?
i've been using the index function with 2 nested match functions,
but
that
only helps with 2 variables

Hello,

Since Excel is a 2-dim sheet tool, you need to represent your 3
dimensions with 2 here.

One approach is to store several x * y arrays in one sheet below each
other (which will then be the z dim).

What dimension is most unlikely to increase? That should be y then, x
should be less equal to 256 in Excel versions before 2007.

With x from 1 to 7, y from 1 to 6 and z from 1 to 5 for example you
can store your values in A1:G6, A11:G16, A21:G26, etc and you look
them up again with
= index(A1:G46, 10 * (z-1) + x, y)

Regards,
Bernd

Close: F7 is not the result, but an equation: .0123 *F7 +1.45
F7 is a representative of where the 3rd variable would be substituted, after
the eqation is called to the calc sheet.
so for example:
with system 1- VAR 1, glass COG .25 - VAR 2, and 89% window Vision - VAR 3
then: index(Match(system 1...),Match(COG .25...))
returns: "0.123*F7 +1.45"
then.. i need something to successfully convert the equation into a formula,
where i can use the 'f7' cell to input the percent, which will calculate a
number

- as well, Pernd P - i've thought of that, what is happening is that i have
over 10 systems, 25 COG values, and infinite range of %'s.. anywhere from
70-95%, so i can't really select it.. it has to be calculated in an equation
that is called

Thanks for helping me out with this...

"T. Valko" wrote:

So, F7 is the result of the lookup and the equation that uses F7 depends on
what sheet is using the equation?

Can't you use an IF function? Of course, this would be limited to a certain
number of nested levels (depending on which version of Excel you're using).

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
the third variable comes into play in the table - for example:
with system 1, and a .30 COG, my index and match functions will call this:
0.014*F7 + 1.50
the F7 is my third variable - the percent vision. So, the 2 dimensional
lookup is not enough for what i need - i need a lookup which looks up the
equation, but than can plug in a value for the percent, depending on what
sheet is calling the equation in the first place - since the % vision is
calculated on another sheet, and changes in every new sheet.
Sorry that this is a little confusing... it's a complicated thing im
trying.

"T. Valko" wrote:

Sorry, I'm not following you on this.

If you have a 2 dimensional lookup table where does the 3rd variable come
into play?

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
sorry.
i have to do some thermal calculations with 3 variables:
system type (so a text)
window vision %,
and Glass COG ( another category)
so far, i've set up a chart on a data sheet with the x axis the COG,
and y
axis a System type.
where those two meet, i'm i have a linear equation (y= mx + b), where y
is
the thermal calc i need, and x is the window percent.

My problem lies where i need to 'call' that equation from the data
sheet,
take it to a window frame sheet, and somehow imput a calculated % into
the
linear equation.
these percents change, so i can't just plug it in to all the equations.

My question is: can i do that somehow? is it also possible to call a
sheet
a variable, so that if the equation is successfully called, it will
input
a
percent that the sheet that called it has calculated?

Hopefully that's a little more detailed...

"T. Valko" wrote:

Not enough detail

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
is there a way to use an array or something similar to calculate a 3
variable
problem, so that different sheets can reference a formula on another
sheet,
and come up with different values, without having multiple formulas?

something similar to 3D arrays?
i've been using the index function with 2 nested match functions,
but
that
only helps with 2 variables

Sorry, I have no other suggestions.

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
Close: F7 is not the result, but an equation: .0123 *F7 +1.45
F7 is a representative of where the 3rd variable would be substituted,
after
the eqation is called to the calc sheet.
so for example:
with system 1- VAR 1, glass COG .25 - VAR 2, and 89% window Vision - VAR 3
then: index(Match(system 1...),Match(COG .25...))
returns: "0.123*F7 +1.45"
then.. i need something to successfully convert the equation into a
formula,
where i can use the 'f7' cell to input the percent, which will calculate a
number

- as well, Pernd P - i've thought of that, what is happening is that i
have
over 10 systems, 25 COG values, and infinite range of %'s.. anywhere from
70-95%, so i can't really select it.. it has to be calculated in an
equation
that is called

Thanks for helping me out with this...

"T. Valko" wrote:

So, F7 is the result of the lookup and the equation that uses F7 depends
on
what sheet is using the equation?

Can't you use an IF function? Of course, this would be limited to a
certain
number of nested levels (depending on which version of Excel you're
using).

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
the third variable comes into play in the table - for example:
with system 1, and a .30 COG, my index and match functions will call
this:
0.014*F7 + 1.50
the F7 is my third variable - the percent vision. So, the 2 dimensional
lookup is not enough for what i need - i need a lookup which looks up
the
equation, but than can plug in a value for the percent, depending on
what
sheet is calling the equation in the first place - since the % vision
is
calculated on another sheet, and changes in every new sheet.
Sorry that this is a little confusing... it's a complicated thing im
trying.

"T. Valko" wrote:

Sorry, I'm not following you on this.

If you have a 2 dimensional lookup table where does the 3rd variable
come
into play?

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
sorry.
i have to do some thermal calculations with 3 variables:
system type (so a text)
window vision %,
and Glass COG ( another category)
so far, i've set up a chart on a data sheet with the x axis the COG,
and y
axis a System type.
where those two meet, i'm i have a linear equation (y= mx + b),
where y
is
the thermal calc i need, and x is the window percent.

My problem lies where i need to 'call' that equation from the data
sheet,
take it to a window frame sheet, and somehow imput a calculated %
into
the
linear equation.
these percents change, so i can't just plug it in to all the
equations.

My question is: can i do that somehow? is it also possible to call
a
sheet
a variable, so that if the equation is successfully called, it will
input
a
percent that the sheet that called it has calculated?

Hopefully that's a little more detailed...

"T. Valko" wrote:

Not enough detail

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
is there a way to use an array or something similar to calculate
a 3
variable
problem, so that different sheets can reference a formula on
another
sheet,
and come up with different values, without having multiple
formulas?

something similar to 3D arrays?
i've been using the index function with 2 nested match functions,
but
that
only helps with 2 variables

Thank you for your effort!