How to use the CHOOSE function
CHOOSE function from list
Most used functions
Weekly Blog EMAIL
Get a FREE PDF book!
Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
The picture above shows the CHOOSE function in cell F3, one disadvantage is that you need to click each cell in the list to build the formula.
If you have a long list that will take some time, however, there is a workaround.
You can quickly convert a cell range to hard-coded values, here are the steps.
Note, you don't need the TRANSPOSE function if your values are arranged horizontally.
However, the CHOOSE function allows you to have up to 254 arguments and perhaps hardcoded values are not what you want. If you have more than 254 values you need another solution, demonstrated below.
The INDEX function allows you to choose a value from a cell range without the need to select each value while building the formula.
CHOOSE function from list.xlsx
The CHOOSE function allows you to retrieve a value based on a number, cell range C3:C4 in the picture above […]
Leave a Comment
Mail (will not be published) (required)
Notify me of followup comments via e-mail
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
You can contact me through this contact form