Vloolup Vs Hlookup Formula in Excel
When you want to pull information from a table, the Excel VLOOKUP function is a typical solution. VLOOKUP is a function to lookup up and retrieve data in a table. The “V” in VLOOKUP stands for vertical, which means the data in the table must be arranged vertically, with data in rows.
VLOOKUP requires that the table be structured so that lookup values appear in the left-most column. The data you want to retrieve (result values) can appear in any column to the right. When you use VLOOKUP, imagine that every column in the table is numbered, starting from the left. To get a value from a particular column, simply supply the appropriate number as the “column index”
To use VLOOKUP, you supply 4 pieces of information, or “arguments”:
The value you are looking for (lookup_value)
The range of cells that make up the table (table_array)
The number of the column from which to retrieve a result (column_index)
The match mode (range_lookup, TRUE = approximate, FALSE = exact)
HLOOKUP searches for a value in the first row of a table. At the match column, it retrieves a value from the specified row. Use HLOOKUP when lookup values are located in the first row of a table.
ange_lookup controls whether value needs to match exactly or not. The default is TRUE = allow non-exact match.
Set range_lookup to FALSE to require an exact match.
If range_lookup is TRUE (the default setting), a non-exact match will cause the HLOOKUP function to match the nearest value in the table that is still less than value.
When range_lookup is omitted, the HLOOKUP function will allow a non-exact match, but it will use an exact match if one exists.
If range_lookup is TRUE (the default setting) make sure that lookup values in the first row of the table are sorted in ascending order. Otherwise, HLOOKUP may return an incorrect or unexpected value.
If range_lookup is FALSE (require exact match), values in the first row of table do not need to be sorted.