Formula in a table header

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

I am trying to put this in a table header cell "=Import!$Q2"
It returns a 0.
How can I get it to return the correct value?
 
=if(import!$q2="","",import!$q2)

(If Q2 on the import sheet is empty, then you'll see that 0.)
 
It still returns a 0 and there is something in the cell. It is actually Q1, I
typed Q2 by mistake.
 
For some reason the header will not hold the formula because the zero it
returns deletes =Import!$Q2
 
Are you using Excel 2007 and Insert>Table?

Table headers cannot be formulas.

If you have a formula the formula will be changed to a static value when you
create the table.

You will be warned of this when you create the table.

If you try to enter the formula after you have created the table, it will
turn to 0................no warning.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement result 1
Formula Not Working Properly 7
HeaderRowRange 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
lastrow function help 6
Find string from column A in Range("B2:F7") list the header of that column/s 5
Post my named ranges in column A 10
Formula for Last Cell in a Row with a Value 5

Back
Top