View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nebulous Nebulous is offline
external usenet poster
 
Posts: 8
Default "This cell is inconsistent with the column formula" error

I get no results from a Google search on this message searched as a phrase,
yet that is word-for-word what Excel is telling me.

Seems simple: I have two worksheets containing tables, "Goal 1" and "Master
List".

In Goal 1:B9, data are entered manually.

In Master List:B9, the formula is simply "='Goal 1'!B9."

Yet when I click on Master List:B9, an exclamation mark appears to the left,
and when I hover over it, it says "This cell is inconsistent with the column
formula."

Is this something unique about references to tables (I've not worked with
tables before)?

Thanks,

~N