Excel 2010: CHOOSE Function

In Excel, CHOOSE function becomes very handy when you need to return the values from the extant list. It takes Index number as a primary argument which searches for the corresponding values in the tilt or string. The syntax includes values which could be a location in the list operating theater self-written groups of values in the argument separated past credit marks. It's genuine usage backside embody seen when you are dealings with big spreadsheet, then it abet users to find out specific keyword from the datasheet rather than searching for it manually.

Launch Stand out 2010 spreadsheet containing important words, text, numbers, etc on which you need to utilize Select office.

new choose

We need to choose selected word from the list and show it in the new Selection column. We leave Be writing a simple function which will help United States to extract cell data by just providing index number.

The syntax of the function is;

=CHOOSE(index_num, value1, value2….)

The first argument need to be the index number of the component which you want to show in new number.

We will be writing the formula as;

=Prefer(3,B2,B3,B4,B5,B6,B7,B8,B9,B10,B11)

As you can see we suffer given the index_num as 3 in the formula, this means that we want to depict the third valuate in the list.

sundev 1

For giving index_num from location, we need to give it with absolute cite. Lets assume we want to regenerate the whole list, we wish just give the absolute reference of the S.No field containing serial Numbers.

The formula bequeath look like this;

=CHOOSE($A$2,B2,B3,B4,B5,B6,B7,B8,B9,B10,B11)

$A$2 is the absolute reference work of the S.No field, it will search the assess in the cell at the emplacemen A2, make the prize index_num, and then use it in convention.

table choose

For using this part exclusively you can also add word Eastern Samoa values, an example is shown in the screenshot below.

choose

You can also check out antecedently reviewed Excel Functions; SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, and LEN.