Post by nShrestha on Dec 23, 2013 13:11:08 GMT 5.75
VLOOKUP is one of the most used function of spreadsheet by the auditor due to its feature that allows the user to match the record of two different worksheets using common column.
Syntax:
=VLOOKUP (lookup_value, table_array, col_index_num, [rang_lookup])
Where
lookup_value = It is the cell reference contain the value that the user to look up.
table_array = It is the data of second worksheet that the user look for lookup_value.
col_index_num = It is the column number with the table_array that the user wish to return.
rang_lookup = This should be either true if user look for exact match or false if user look for closest match.
Example: =vlookup(d2,sheet2!d2:e14, sheet2!e2, false)
![]()
Syntax:
=VLOOKUP (lookup_value, table_array, col_index_num, [rang_lookup])
Where
lookup_value = It is the cell reference contain the value that the user to look up.
table_array = It is the data of second worksheet that the user look for lookup_value.
col_index_num = It is the column number with the table_array that the user wish to return.
rang_lookup = This should be either true if user look for exact match or false if user look for closest match.
Example: =vlookup(d2,sheet2!d2:e14, sheet2!e2, false)