Menu

function which includes its own list - no table

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Posted to microsoft.public.excel.programming

Claus Busch Claus Busch is offline

Claus Busch is offline

external usenet poster

Posts: 3,872

Default

function which includes its own list - no table

Hi,

Am Fri, 3 Jan 2014 08:48:39 -0800 (PST) schrieb :

choose().

you can also use INDEX. Then you have to write your characters as array:
=INDEX({"m";"t";"w";"r";"f"},C4)

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I get drop-down list that includes, eg top10	RichardHouse	Excel Worksheet Functions	1	March 16th 10 10:41 AM
How can I count up values in a list that includes duplicates?	cbruton1975	Excel Discussion (Misc queries)	2	September 29th 06 08:09 PM
How to choose from a list that includes blanks?	Air_Step	Excel Discussion (Misc queries)	3	March 24th 06 11:44 AM
Drop down list includes hyperlink	Mark Renfrow	Excel Discussion (Misc queries)	1	July 6th 05 08:23 PM
Cannot protect worksheet if it includes a list	Elladene	Excel Worksheet Functions	0	June 23rd 05 08:09 PM

All times are GMT +1. The time now is 10:32 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement