If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CHOOSE function - more than 29 items
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|