"Sara" wrote
... {TABLE (,B45)}

The above is a formula refering to a 1-variable data table.
It has to be set-up via clicking the Data Table menu
(it *cannot* be typed in and entered like a "normal" array formula)

Type: 'data tables' in Excel's help for more info

There's also a 2-variable data table which reads
both row and column inputs to output what-if results

This link has a pdf file which covers the data-table topic
in some detail (watch the line wrap):
http://it.fuqua.duke.edu/public/2001...Monochrome.pdf

Try also: http://tinyurl.com/5b7uf
for a simple example set-up for a 1-variable
and a 2-variable data table
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--