Limitations to 2 variable data tables?
 

I'm getting an odd result with 2 variable data tables in a complex
spreadsheet - only the 1st (top left) cell returns the proper value, the rest
are either zero (or Div/0! errors if I try to return a percentage result).
The data table evaluates the result of a very complex formula [resulting from
offset(), vlookup() & if() statements]. However, 1 variable data tables work
correctly for each of the two variables I want in the 2 variable data table.
Can anyone shed any light on this?

Limitations to 2 variable data tables?
 

You would really need to post your formula - but it is likely that you need to change some cell
addresses to absolute column, and others to absolute rows. For example, to create a table from
variables in row 1 and column A, you would change this formula in cell B2

=B1*A2

to this

=B$1 * $A2

to copy to, say, B2:G10

HTH,
Bernie
MS Excel MVP


"DInwood" wrote in message
...
I'm getting an odd result with 2 variable data tables in a complex
spreadsheet - only the 1st (top left) cell returns the proper value, the rest
are either zero (or Div/0! errors if I try to return a percentage result).
The data table evaluates the result of a very complex formula [resulting from
offset(), vlookup() & if() statements]. However, 1 variable data tables work
correctly for each of the two variables I want in the 2 variable data table.
Can anyone shed any light on this?

Limitations to 2 variable data tables?
 

Just some guesses ..

Maybe try re-doing the Data Table set-up, swap the row & col input cells
around (you might have done it the wrong way around earlier?). If the results
are still out, check whether there could be combinations of "row-input"
values entered to the right of the top left cell & "col-input" values entered
below the top left cell which would lead to output zeros/errors by plugging
some sample combinations of these directly into the base formula itself.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DInwood" wrote:
I'm getting an odd result with 2 variable data tables in a complex
spreadsheet - only the 1st (top left) cell returns the proper value, the rest
are either zero (or Div/0! errors if I try to return a percentage result).
The data table evaluates the result of a very complex formula [resulting from
offset(), vlookup() & if() statements]. However, 1 variable data tables work
correctly for each of the two variables I want in the 2 variable data table.
Can anyone shed any light on this?