HELP! Setting CHOOSE [Value] to Cell Content

[a_team_murdock]

Hi:

I was wondering how you would set the CHOOSE functions' Value to a cell's content?

Example: A1 = 2,3,5,6,7,8

and I want that "2,3,5,6,7,8" to go into CHOOSE(5,A1) to =7 but it won't work... it takes it as text because it is...

In thinking an indirect or something? I know it's simple, but I just can't figure it out!

Any help would be appreciated.


Thank you kindly,



Al

 

[Robert Mika]

For CHOOSE you need an array as second argument
Try this

=CHOOSE(B3,LEFT(A1,1),MID(A1,3,1),MID(A1,5,1),MID(A1,7,1),MID(A1,9,1),MID(A1,11,1),MID(A1,13,1))

where B3 is your number to choose from