#Value Problem - Inconsistent Formulas After Column Insertions
 

Using Excel 2007. Workbook was originally 2003.

I cannot find a way around the "inconsistent formula" problem that causes
the total column at the end of the worksheet to return the #VALUE error.

There are 6 columns in the worksheet that use IF, AND and VLOOKUP formulas.
The cells with the formulas have one columen with another formula in it. The
first 4 columns with the formula that I am using do not have the
"inconsistent formula" problem. The last 4 of the group does. The only
difference between any of the columns is the column number for the data to be
pulled from. i.e., the same formula referencing to the same worksheet.

The only thing that I popping out to me at the moment is that I inserted
these 4 columns in the worksheet. As stated it is a 2003 worksheet and am
using 2007. The active content being disabled and/or enabled doesnt make a
difference. I have addtiionally killed all the links to other workbooks.

Any assistance would be appreciated.

#Value Problem - Inconsistent Formulas After Column Insertions
 

See your other post

--
Biff
Microsoft Excel MVP


"dpridemore" wrote in message
...
Using Excel 2007. Workbook was originally 2003.

I cannot find a way around the "inconsistent formula" problem that causes
the total column at the end of the worksheet to return the #VALUE error.

There are 6 columns in the worksheet that use IF, AND and VLOOKUP
formulas.
The cells with the formulas have one columen with another formula in it.
The
first 4 columns with the formula that I am using do not have the
"inconsistent formula" problem. The last 4 of the group does. The only
difference between any of the columns is the column number for the data to
be
pulled from. i.e., the same formula referencing to the same worksheet.

The only thing that I popping out to me at the moment is that I inserted
these 4 columns in the worksheet. As stated it is a 2003 worksheet and am
using 2007. The active content being disabled and/or enabled doesnt make
a
difference. I have addtiionally killed all the links to other workbooks.

Any assistance would be appreciated.