How to use VLOOKUP AND HLOOKUP formula in Excel with Example Download

If you want to find data in the same or different worksheet in Excel, vlookup and hlookup formulas would help. In this tutorial we show you the quick way to find mention or grade with vlookup and hlookup.

VLOOKUP formula in Excel

VLOOKUP returns a value in the same row from a specify column that match the value you looking for in the table.
FORMULA:

=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

◾ lookup_value: Required, value you want to look up.
◾ table_array: required, The range of cells in which the VLOOKUP will search for the lookup_value and the return value.
◾col_index_num:required,The column number that contains the return value
◾range_lookup:optional

HLOOKUP formula in Excel

HLOOKUP looks for a value in the top row of a table and returns the value in the same column from a row you specify
FORMULA:

=HLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

◾ lookup_value: Required, The value to be found in the first row of the table.
◾ table_array: required, A table of information in which data is looked up.
◾col_index_num:required,The row number in table_array from which the matching value will be returned.
◾range_lookup:optional
Watch How to use VLOOKUP AND HLOOKUP formula in Excel speak Khmer

ads

How to use VLOOKUP AND HLOOKUP formula in Excel with Example Download