LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible? DakotaNJ Excel Worksheet Functions 25 September 18th 06 09:30 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
how do i copy formula and change worksheet instead of cell dal0506 Excel Worksheet Functions 2 January 21st 05 08:41 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 05:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"