CHOOSE function - more than 29 items

A

amanda

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables. 0
Using the list form control: multi-selection possible? 3
Trying to randomly choose a number from a set list of numbers 8
Change Color of Cell based on Date and today's date. 1
Financial Time Value of Money calculations 5
"OR" Function in an Array Formula 3
Use TODAY() function as the criteria in a SUMIF formula 1
Pricing Chart 3

Top