Thread: #VALUE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dpridemore dpridemore is offline
external usenet poster
 
Posts: 9
Default #VALUE

I am getting a #VALUE error when trying to add a series of data in different
cells.

Apparently this is due to an "inconsistent formula" with others in the same
area of the worksheet.

I have a list of data that I am accessing through IF, AND, and VLOOKUP
functions. The cell in one column will not show any "inconsistent formula"
errors and provides the correct data. When the formula is moved two cells to
the right and the VLOOKUP function adjusted by 2 columns to make sure it
picks up the correct data then the "inconsistent formula" error is shown.

This is happening on three columns in the worksheet. The good column will
pick up data from the table at column 14. The second will pick up on 11. The
third on column 10. The third on column 16.

Any help would be greatly appreciated.