#lookup; #vlookup; #hlookup
Lookup function
Purpose of Lookup function is to identify a value in a single row/column and return value from the same position in a second row or column.
lookup_value - The value to search for.
lookup_vector - The one-row, or one-column range to search.
result_vector - [optional] The one-row, or one-column range of results.
Vlookup function
Vlookup stands for vertical look up function. this function is mainly used for finding the particular data is present in a column of given table. Below is the syntax of vlookup
Lookup_value - The value to look for in the column of a table.
table - The table from which to retrieve a value.
column_index - The column in the table from which to retrieve a value.
range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.
Hlookup function
Hlookup stands for Horizontal lookup function. this function is mainly used for finding the particular data is present in rows of given table. Below is the syntax of Hlookup
Lookup_value - The value to look for in the first row of a table.
table_array - The table from which to retrieve a value.
row_index - The row in the table from which to retrieve a value.
range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.
Conclusion: The Microsoft Excel is a most useful application for managing data in a spreadsheet. Lookup function like Vlookup and Hlookup function which are used to find specific data in the excel sheet. This function is very useful as it easily locates the data or the value.
An important point to remember is the Hlookup function will find data from top to bottom (rows in the selected range) and vlookup function find data from left to right (columns in the right side)
Syntax: lookup (lookup_value,lookup_vector ,[result_vector])
lookup_value - The value to search for.
lookup_vector - The one-row, or one-column range to search.
result_vector - [optional] The one-row, or one-column range of results.
Vlookup function
Vlookup stands for vertical look up function. this function is mainly used for finding the particular data is present in a column of given table. Below is the syntax of vlookup
Syntax: VLOOKUP (lookup_value, table_array, column_index, [range_lookup])
Lookup_value - The value to look for in the column of a table.
table - The table from which to retrieve a value.
column_index - The column in the table from which to retrieve a value.
range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.
Hlookup function
Hlookup stands for Horizontal lookup function. this function is mainly used for finding the particular data is present in rows of given table. Below is the syntax of Hlookup
Syntax: HLOOKUP (Lookup_value, table_array, row_index, [range_lookup])
Lookup_value - The value to look for in the first row of a table.
table_array - The table from which to retrieve a value.
row_index - The row in the table from which to retrieve a value.
range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.
Conclusion: The Microsoft Excel is a most useful application for managing data in a spreadsheet. Lookup function like Vlookup and Hlookup function which are used to find specific data in the excel sheet. This function is very useful as it easily locates the data or the value.
An important point to remember is the Hlookup function will find data from top to bottom (rows in the selected range) and vlookup function find data from left to right (columns in the right side)
0 Comments
Please do not spam