vlookup and hlookup

Vlookup

VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, for partial matches. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.

Example :

No	Name
1	Arum
2	Vindi
3	Vilya

 

Rumus : VLOOKUP(lookup value;table array ;col_index;range_lookup)

Explaination :

1. Lookup value : The value in the reference to read the reference table (this value must exist both in the table in the content or on the table references
2. Table array : Range from the table containing the refference data to fill the expected result (make sure that the range you selected does not include the column headings)
3. Col_index: No data sequence in the reference table starting from the leftmost column on the refrence table with no index and so on
4. Range_lookup:
   • Value is true: if the data value is uncertain / is in a certain range
   • False value: if the value of the data is precious
    

 

HLOOKUP

This function is to input data in the table based on data in refference table or other specified table, using a specific key value. The table refrenai used is horizontal, where the column headings are located on the left and the data is arranged to the right in the horizontal direction.

Example :

No	1	2	3
Name	Vinsi	Arwen	Vilya

Rumus : HLOOKUP(lookup value;table array ;row_index_num;range_lookup)

Explaination

1. lookup value: The value that is used as a reference to read the reference table (this value must exist both in the table in the content or on the table references
2. table array : Range from the table containing the reference data to fill the expected result (make sure that the range you selected does not include the column headings)
3. row_index_num : No data sequence in the reference table starting from the leftmost column on the refrence table with no index and so on
4. range_lookup:
   • Value is true: if the data value is uncertain / is in a certain range
   • False value: if the value of the data is precious