## CHOOSE function from list

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.

- Double click a cell
- Type =CHOOSE(E3,TRANSPOSE(C3:C12))
- Select TRANSPOSE(C3:C12) in the formula with your mouse
- Press function key F9 to convert the cell reference to values
- Delete the curly brackets { }
- Press Enter

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.

### Download Excel *.xlsx file

How to use the CHOOSE function

The CHOOSE function allows you to retrieve a value based on a number, cell range C3:C4 in the picture above […]

### Leave a Reply

### How to comment

**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.

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org or imgur

Paste image link to your comment.

**Contact Oscar**

You can contact me through this contact form