Two Variable Data Table Issue

[pxprice]

I have a problem with a two variable data table. For some reason the variables in column one (under 36.77) are the same as column headed (60.00). However, when column 60.00 changes to 36.77, the variables in column one also changes. See before and after below:

Before:
13.0% 36.77 30.00 40.00 50.00 60.00
11.7% 13.0% 15.0% 12.1% 9.9% 8.1%
15.0% 8.6% 15.5% 12.6% 10.4% 8.6%
17.0% 8.9% 15.8% 13.0% 10.7% 8.9%
21.0% 9.6% 16.6% 13.7% 11.5% 9.6%
23.0% 10.1% 17.0% 14.1% 11.9% 10.1%

After:
13.0% 36.77 30.00 40.00 50.00 36.77
11.7% 13.0% 15.0% 12.1% 9.9% 13.0%
15.0% 13.5% 15.5% 12.6% 10.4% 13.5%
17.0% 13.8% 15.8% 13.0% 10.7% 13.8%
21.0% 14.6% 16.6% 13.7% 11.5% 14.6%
23.0% 15.0% 17.0% 14.1% 11.9% 15.0%

Can you help as the rest of the table works fine.

[tarquinious]

I have a problem with a two variable data table. For some reason the variables in column one (under 36.77) are the same as column headed (60.00). However, when column 60.00 changes to 36.77, the variables in column one also changes.

It's extremely difficult to know what is going on here without seeing your spreadsheet and knowing what those formulas are doing, however, just looking at your examples, it looks like your formulas under each heading value are referring to the heading value. Therefore when you change the heading "60.00" to "36.77" your formulas below are using the 36.77 and coming up with the same results as are in the column with the heading 36.77.

Without more info, I'm in the dark other than to say: my guess is that Excel is using that header figure in the formula.