Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
how do i copy formula and change worksheet instead of cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |