Choose Function

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

=CHOOSE(A1-29,.................

Or look at the INDEX() function in HELP

--
Kind regards,

Niek Otten

"UD 9" <UD.9.1z2mqy_1132953301.5682@excelforum-nospam.com> wrote in message
news:UD.9.1z2mqy_1132953301.5682@excelforum-nospam.com...
>
> 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
>