Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What does allcalc (a table_array) refer to in a cell formula?
I'm using a spreadsheet that looks up data in different worksheets. The term
"allcalc" is used. A cell's formula reads: =+HLOOKUP($C$9,allcalc,driver!$A$35,FALSE). "driver" is the name of the worksheet, what does allcalc do? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What does allcalc (a table_array) refer to in a cell formula?
I would assume it is a named range for the lookup table range
Do you see it when you click on the NameBox? or nder InsertNameDefine.........2003 or FormulasDefine Name..........2007 Gord Dibben MS Excel MVP On Tue, 29 Sep 2009 13:55:01 -0700, Seabreezin wrote: I'm using a spreadsheet that looks up data in different worksheets. The term "allcalc" is used. A cell's formula reads: =+HLOOKUP($C$9,allcalc,driver!$A$35,FALSE). "driver" is the name of the worksheet, what does allcalc do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refer cell value as part of formula | Excel Worksheet Functions | |||
How do I refer to cell in another worksheet in a formula | Excel Worksheet Functions | |||
Use cell contents to refer to a sheetname in a formula | Excel Worksheet Functions | |||
how i can refer to cell in long formula go to another file | Excel Discussion (Misc queries) | |||
How do I refer to the tab name in a cell formula in Excel? | Excel Discussion (Misc queries) |