Adding more arguments to =CHOOSE function?

**osbertdebroilg** · 05-29-2012, 07:06 PM

Hi,

Please could you provide mw with a dummy example using the correct syntax ?

i.e.

=IF(I10<=20,CHOOSE("a","b","c","d"),CHOOSE(MOD(I10,20),"Clarinet",)) etc

many thanks

**martindwilson** · 05-29-2012, 07:21 PM

=IF(B1<=29,CHOOSE(B1,1,2,3,4,5,6,7,8,9,10,….29),CHOOSE(B1-29,"a","b",…………..))

**osbertdebroilg** · 05-30-2012, 08:14 AM

Hi, many thanks for such a quick reply. I'm not sure it answers my problem though - but that's my fault for not explaining. What I need to do is to overcome the limit of 29 arguments in CHOOSE.

I.e. I type a number between say 1 and 40 and it returns the linked word in the other cell.

I'm sorry if im being thick, but any help much appreciated!

Thanks,

G

**martindwilson** · 05-30-2012, 09:04 AM

all of the above should work but lookup would be easier eg in g1:g40 number down 1 to 40 then put what each one represents in h1:h40
then use=lookup(a1,g1:h40) where a1 is your number