Hlookup Formula In Excel. What is the hlookup function. The h in hlookup stands for horizontal where lookup values appear in the first row of the table moving horizontally to the right.
Hlookup supports approximate and exact matching and wildcards for finding partial matches. Formula hlookup value to look up table area row number. This article describes the formula syntax and usage of the hlookup function in microsoft.
Formula hlookup value to look up table area row number.
Click the cell where you want to place the function s result then go to the formulas tab and select the lookup and reference tool in the function and library group in the drop down menu. Hlookup supports approximate and exact matching and wildcards for finding partial matches. 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. While vlookup searches for the value in a column hlookup searches for the value in a row.
