I have seen an array function used {=TABLE(,Cell ref)} which changes the
value of a cell depending on the value of cell ref cell. Does any one know
how it works

{=TABLE(,Cell ref)}

Its a "one variable data table" which is used for sensitivity analysis.
Albeit it looks like an array formula, it's not. The table needs to be set up
via the menu command: Data Table..

You could try typing in Excel's help: one variable data table
for more information

I also have 2 data table samples in my archives:

http://savefile.com/files/1007074
One variable data table example.xls

http://savefile.com/files/46276
2 variable data table example.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gregory OUSTED" wrote:
I have seen an array function used {=TABLE(,Cell ref)} which changes the
value of a cell depending on the value of cell ref cell. Does any one know
how it works