View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John
 
Posts: n/a
Default Cell just shows formula after named region var change

All of a sudden some of my new formulas are appearing as the cell content
instead of the content being the value of the formula. Specifically, I have
several report sheets that show data from a database table range referenced
by cell named 'dedb' that look like:

=IF(VLOOKUP(dewono,INDIRECT(dedb),COLUMN(contact), FALSE)<"",VLOOKUP(dewono,INDIRECT(dedb),COLUMN(co ntact),FALSE),"__________")

I added a new column in my database range called tcontact and named to, but
when I copy the above formula to a cell to reference the new column, it does
not evaluate. It just shows:

=IF(VLOOKUP(dewono,INDIRECT(dedb),COLUMN(tcontact) ,FALSE)<"",VLOOKUP(dewono,INDIRECT(dedb),COLUMN(t contact),FALSE),"__________")

What's going on here? I do have over 500 named ranges in my workbook, and
the workbook file is around 700KB, but I wouldn't think I was running out of
room or resources.

Appreciate your help.