What does allcalc (a table_array) refer to in a cell formula?

  • Thread starter Thread starter Seabreezin
  • Start date Start date
S

Seabreezin

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?
 
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 Insert>Name>Define.........2003

or Formulas>Define Name..........2007


Gord Dibben MS Excel MVP
 
Back
Top