Hlookup Vlookup In Excel. Hlookup stands for horizontal lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. The vlookup function assumes that your data is arranged as a table with different elements of the.
While vlookup searches for the value in a column hlookup searches for the value in a row. Hlookup stands for horizontal lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. The h in the hlookup stands for horizontal and hence it is often called horizontal lookup.
Hlookup function in excel is a sibling of the vlookup function.
The vlookup and hlookup formula in excel is the two most important and widely used functions of excel. Use hlookup when lookup values are located in the first row of a table. Hlookup function in excel is a sibling of the vlookup function. Let s now look at an even more important issue with the lookup functions.
