Excel Function

CHOOSE

Returns a value from a list by index.

CHOOSE(index_num, value1, [value2], ...)

Arguments

index_num

Required

Enter a numeric value.

value1

Required

Enter a text value (wrap with quotes when needed).

Practice Preview

show outputs based on conditions. Use CHOOSE to Returns a value from a list by index. use 2 for index_num, use "低" for value1. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=CHOOSE(2, "低")

Practice This Function