Prev: Simple hack to get $500 to your home.
Next: Can I make a column automatically organize the cells numerically?
From: amanda on 2 Jun 2010 13:47
Hi,

Is there a way of using the CHOOSE function if you have more than 29 values?
AND
Is there a way of avoiding typing in all of the 29 (or more) values into the
formula box?

Thank you
From: Gord Dibben on 2 Jun 2010 14:20
Wouldn't VLOOKUP with a lookup table be better suited than a great whack of
values in one CHOOSE formula?

Or with a list of sorted values in A1:A34 and a list of values in B1:B34

In D1 enter =LOOKUP(C1,A1:A34,B1:B34)

Enter a lookup value in C1


Gord Dibben MS Excel MVP

On Wed, 2 Jun 2010 10:47:55 -0700, amanda <amanda(a)discussions.microsoft.com>
wrote:

>Hi,
>
>Is there a way of using the CHOOSE function if you have more than 29 values?
>AND
>Is there a way of avoiding typing in all of the 29 (or more) values into the
>formula box?
>
>Thank you

 | 
Pages: 1
Prev: Simple hack to get $500 to your home.
Next: Can I make a column automatically organize the cells numerically?