CHOOSE function - more than 29 items
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
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
|