You should read
=CHOOSE(3, A2, B3, C4, D5, E6) will return C4 <-- and not A4 !!!

Corrected post below:

Ali,

You could use the CHOOSE function which returns the nth value. For example,
=CHOOSE(3, A2, B3, C4, D5, E6) will return C4, the third value in the array
{A2, B3, C4, D5, E6}. This works well if the cells are not contiguous, but
you are limited to 30 values if I remember well.

If your values are in contiguous cells (same column for example), you can use
the INDEX function, something like =INDEX(B1:B50, 3) which will retrieve the
third cell in the range, i.e. the content of B3.

Replace 3 in the formula above with INT(NOW()-DATE(2007, 08,14)) and this way,

each day your cell content will display a different value.

Stephane.

--
Message posted via http://www.officekb.com