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