writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + − + − + − + − + − + − + Line 17:
Line 18: − + − + − + − + − + − +
no edit summary
=VLOOKUP(lkup_val, table_arr, column_index_num, range_lkup)=
=VLOOKUP(lkup_val, table_arr, column_index_num, range_lkup)=
<div style="font-size:30px">'''VLOOKUP (Value,Array,Column,ApproximateMatchFlag) '''</div><br/>
where,
where,
*'''lkup_val''' is the value to be matched from an array or first column of the table,
*'''Value''' 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,
*'''Array''' refers to two or more columns of data values,
*'''column_index_num''' is the column number in the table from which the matching value should be returned, and
*'''Column''' 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 whether to find an exact match or approximate match of the mentioned lookup value.
*'''ApproximateMatchFlag''' 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 specified column in the table array.
VLOOKUP(), looks in the first column of an array and moves across the row to return the value of a cell.
== Description ==
== Description ==
VLOOKUP(lkup_val, table_arr, column_index_num, range_lkup)
VLOOKUP (Value,Array,Column,ApproximateMatchFlag)
*The 'V' in VLOOKUP stands for vertical. This function looks the value column wise.
*The 'V' in VLOOKUP stands for vertical. This function looks the value column wise.
*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 '''Value''' 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 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.
*If '''Column''' 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''' < 1 or '''Column''' > '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.
*Argument '''range_lkup''' can be TRUE or FALSE.
*Argument '''ApproximateMatchFlag''' can be TRUE or FALSE.
*If '''range_lkup''' is TRUE or Omitted, Calci returns exact or approximate match of the value.
*If '''ApproximateMatchFlag''' is TRUE or Omitted, Calci returns exact or approximate match of the value.
*Approximate value is the largest value that is <= '''lkup_val'''.
*Approximate value is the largest value that is <= '''lkup_val'''.
*If '''range_lkup''' is FALSE, Calci searches only for the exact match. If exact match is not found, Calci returns #NULL error message.
*If '''ApproximateMatchFlag''' is FALSE, Calci searches only for the exact match. If exact match is not found, Calci returns #NULL error message.
*For invalid arguments, Calci displays #NULL error message.
*For invalid arguments, Calci displays #NULL error message.