How do I use Hlookup in Excel 2010?

Uses of Hlookup Function

Table of Contents

Select the cell C9 and write the formula.
=HLOOKUP(C8,$C$2:$G$3,2,false) press enter.
The function will return the joining date for this L1056 Emp code.
To return the date of joining to all the employees, Copy the same formula and paste in the range D9:G9.

How does Hlookup work 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. While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row.

What is Hlookup formula?

Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows.

How do I use VLOOKUP and Hlookup together?

Learn How to Use VLOOKUP and HLOOKUP Together in Excel

Lookup_Value: This is the value to search for.
Lookup_array: This is the range to search for the lookup value.
HLOOKUP: This serves as the COLUMN NUMBER in the VLOOKUP formula.
Range_lookup: This is used to specify if we want an approximate or exact match.

What is table array in Hlookup?

HLOOKUP in Excel stands for ‘Horizontal Lookup’. It is a function that makes Excel search for a certain value in a row (the so called ‘table array’), in order to return a value from a different row in the same column.

Why is Hlookup used?

Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find. The H in HLOOKUP stands for “Horizontal.”