[PDF]Choose Function In Excel

Imparting knowledge

Gyan Sangrah

Choose function in excel

In this article, we will discuss choose function in excel

Purpose

Choose function returns the value from the list using an index.

Syntax

=Choose( Index,value1_from_list, value2_from_list,...)



Example


A

B

C D

1 E _.


A

B

C

D

E

|=CH00SE(1,B1,C1,D1,E1)|

iPoor

[Average [Good

|Bravo 1 1

Poor


Poor

Average

Good

Bravo

A

B

C D

1 E 1 _.


A

B

C

D

E

|=CH00SE(2,B1,C1,D1,E1)

IPoor

[Average iGood

[Bravo [

*-‘

Average


Poor

Average

Good

Bravo

CHOOSE(index_num, value 1. [value2], [value3], [value4], [value5], [value6],...)


i


_ 1




A

B

C D

E


A

B

C

D

E

|=CH00SE(3,B1,C1.D1,E1)

[Poor

1 Average IGood

[Bravo [ |-

Good


Poor

Average

Good

Bravo

rHOOSFfinde* num valuel [value?! [valued! fvaliie41 [valiieSl [valupfil 1 1