<div class="raw-html-embed">	The VLOOKUP function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#lookupreference" onclick="onhyperlinkclick(this)">lookup and reference functions</a>. It is used to perform the vertical search for a value in the left-most column of a table or an array and return the value in the same row based on a specified column index number.

	<h5 class="pt8">Syntax</h5>
	VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
	The VLOOKUP function has the following arguments:
	<table style="width: 40%">
		<tbody>
			<tr>
				<th style="background-color: #f4f4f4" width="150ch">Argument</th>
				<th style="background-color: #f4f4f4">Description</th>
			</tr>
			<tr>
				<td>lookup_value</td>
				<td>A value to search for.</td>
			</tr>
			<tr>
				<td>table_array</td>
				<td>Two or more columns containing data sorted in ascending order.</td>
			</tr>
			<tr>
				<td>col_index_num</td>
				<td>A column number in the table_array, a numeric value greater than or equal to 1 but less than the number of columns in the table_array.</td>
			</tr>
			<tr>
				<td>range_lookup</td>
				<td>A logical value TRUE or FALSE. It is an optional argument. Enter FALSE to find an exact match. Enter TRUE or omit this argument to find an approximate match, in this case if there is not a value that strictly matches the lookup_value, then the function will choose the next largest value less than the lookup_value.</td>
			</tr>
		</tbody>
	</table>

	<h5 class="pt8">Notes</h5>
	If the range_lookup is set to FALSE, but no exact match is found, then the function will return the #N/A error.
	<a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the VLOOKUP function.

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

VLOOKUP Function

Docs

Argument	Description
*lookup_value*	A value to search for.
*table_array*	Two or more columns containing data sorted in ascending order.
*col_index_num*	A column number in the *table_array, a numeric value greater than or equal to 1 but less than the number of columns in the table_array*.
*range_lookup*	A logical value TRUE or FALSE. It is an optional argument. Enter FALSE to find an exact match. Enter TRUE or omit this argument to find an approximate match, in this case if there is not a value that strictly matches the *lookup_value, then the function will choose the next largest value less than the lookup_value*.

VLOOKUP Function

Syntax

Notes

Examples

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