Article updated on January 10, 2018

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.

=CHOOSE(E3,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12)

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.

  1. Double click a cell
  2. Type =CHOOSE(E3,TRANSPOSE(C3:C12))
  3. Select TRANSPOSE(C3:C12) in the formula with your mouse
  4. Press function key F9 to convert the cell reference to values
  5. Delete the curly brackets { }
  6. Press Enter
=CHOOSE(E3,"B","F","J","I","A","E","G","D","H","C")

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.

=INDEX(C3:C12,E3)

Download Excel *.xlsx file

CHOOSE function from list.xlsx