# Thread: Lacking any brain power!!! (Excel 97 and >)

1. ## Lacking any brain power!!! (Excel 97 and >)

<img src=/S/hello.gif border=0 alt=hello width=25 height=29> Loungers

OK what form of a worksheet formula will I need to use to pick from a list?

For example if I have something like =SomeFormula(A1,("Monday,Tuesday,Wednesday,Thursda y,Friday,Saturday,Suday")) then if A1 has 3 the formula will evaluate to Wednesday. If A1 has 7 the formula will evaluate to Sunday.

What will be the form of SomeFormula?

Thanks a lot for helping me when I am not with my full capacity

Wassim

2. ## Re: Lacking any brain power!!! (Excel 97 and >)

=INDEX({"Monday","Tuesday","Wednesday","Thursday", "Friday","Saturday","Suday"},A1)

Will work..

Regards
Peter

3. ## Re: Lacking any brain power!!! (Excel 97 and >)

=CHOOSE(A1,"Monday","Tuesday","Wednesday","Thursda y","Friday","Saturday","Sunday")
will also work with a list

Also you could use the simple formula:
=A1+1
and formatting is as (no quotes): "dddd" to display the weekdays

or place the names of the weekdays in the cells (eg) B1:B7 and using:
=index(B1:B7,A1)

Steve

4. ## Re: Lacking any brain power!!! (Excel 97 and >)

<img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Peter

I am suffering from a huge summer cold <img src=/S/headthrob.gif border=0 alt=headthrob width=15 height=15>, and I need to get in bed <img src=/S/nosleep.gif border=0 alt=nosleep width=27 height=15> and rest, but I have this project that I need to work on.

Is there a limit, of how many items I can lookup, to the Index function, or maybe I'll hit the max length of the formula before I have a limit?

Thanks a million.

Wassim

5. ## Re: Lacking any brain power!!! (Excel 97 and >)

Wassim.. hope the cold improves... in terms of your question.. Don't no.. but:

=INDEX(A:A,65536)

Works without problems.. i.e. Using ALL of column A as the array with the values works ok..

Regards
Peter

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•