=CHOOSE(A1-29,.................
Or look at the INDEX() function in HELP
--
Kind regards,
Niek Otten
"UD 9" wrote in message
...
I need to find a way to either
a) extend the choose function to handle more than 29 values or
B) change the index number so that it would read, for example, 30-59
instead of 1-29
any help would be apprieciated as I want to have a worksheet or a
series of worksheets that would have approx 170 colums of information
that would move beside the headings by entering a # therefore making it
easier to read.
Thanx
--
UD 9
------------------------------------------------------------------------
UD 9's Profile:
http://www.excelforum.com/member.php...o&userid=29104
View this thread: http://www.excelforum.com/showthread...hreadid=488269