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