Changes

*'''lkup_val''' is the value to be matched from an array or first column of the table,

*'''lkup_val''' is the value to be matched from an array or first column of the table,

*'''table_arr''' refers to two or more columns of data values,

*'''table_arr''' refers to two or more columns of data values,

*'''column_index_num''' is the column number in the table from which the matching should be returned, and  

*'''column_index_num''' is the column number in the table from which the matching value should be returned, and  

*'''range_lkup''' is an optional logical value that specifies to find an exact match or approximate match of the mentioned lookup value.

*'''range_lkup''' is an optional logical value that specifies whether to find an exact match or approximate match of the mentioned lookup value.

VLOOKUP() looks up for a value in the first column of a table array and gives a value in the same row from another column in the table array.

VLOOKUP() looks up for a value in the first column of a table array and gives a value in the same row from specified column in the table array.

== Description ==

== Description ==

*VLOOKUP function is not case-sensitive.

*VLOOKUP function is not case-sensitive.

*If '''lkup_val''' is less than 'smallest value in first column of table', Calci displays #NULL error message.

*If '''lkup_val''' is less than 'smallest value in first column of table', Calci displays #NULL error message.

*If '''column_index_num''' is 1, Calci returns the value in first column in table array. If '''column_index_num''' is 2, Calci returns the value in second column in table array and so on.

*If '''column_index_num''' is 1, Calci returns the value from the first column in table array. If '''column_index_num''' is 2, Calci returns the value from the second column in table array and so on.

*For '''column_index_num''' < 1 or '''column_index_num''' > 'number of columns in array', Calci returns #NULL error message.

*For '''column_index_num''' < 1 or '''column_index_num''' > 'number of columns in array', Calci returns #NULL error message.

*The values in first column should be arranged in ascending order for correct results.

*The values in first column should be arranged in ascending order for correct results.

== Examples ==

== Examples ==

Following table shows the use of VLOOKUP function in '''Vector Form''' -

Following table shows the use of VLOOKUP function -

<div id="2SpaceContent" class="zcontent" align="left">

<div id="2SpaceContent" class="zcontent" align="left">