<div class="raw-html-embed">	<p>The <b>CHOOSE</b> function is one of the <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#lookupreference" onclick="onhyperlinkclick(this)">lookup and reference functions</a>. It is used to return a value from a list of values based on a specified index (position).</p>

	<h5 class="pt8">Syntax</h5>
	<p><b><em>CHOOSE(index_num, value1, [value2], ...)</em></b></p>
	<p>The <b>CHOOSE</b> function has the following arguments:</p>
	<table style="width: 40%">
		<tbody>
			<tr>
				<th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
				<th style="background-color: #f4f4f4"><b>Description</b></th>
			</tr>
			<tr>
				<td><b><em>index_num</em></b></td>
				<td>The position of the value in the list of values, a numeric value greater than or equal to 1 but less than the number of the number of values in the list of values.</td>
			</tr>
			<tr>
				<td><b><em>value1/2/n</em></b></td>
				<td>The list of values or the selected range of cells you need to analyze.</td>
			</tr>
		</tbody>
	</table>

	<h5 class="pt8">Notes</h5>
	<p><a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the <b>CHOOSE</b> function.</p>

	<h5 class="pt8">Examples</h5>
	<p>The figure below displays the result returned by the <b>CHOOSE</b> function.</p>
	<p><img alt="CHOOSE Function" src="https://static-helpcenter.teamlab.info/choose_7b30b15049.png"></p></div>

CHOOSE Function

Docs

Argument	Description
*index_num*	The position of the value in the list of values, a numeric value greater than or equal to 1 but less than the number of the number of values in the list of values.
*value1/2/n*	The list of values or the selected range of cells you need to analyze.

CHOOSE Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud