The HLOOKUP formula in Excel is used to search for a value in the first row of a range (table or array) and return a corresponding value from a specified row within that range. It is similar to the VLOOKUP formula, but it looks horizontally instead of vertically.
Here's the syntax of the HLOOKUP function:
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Lookup_value: This is the value you want to search for in the first row of the table_array.
Table_array: This is the range of cells that contains the data you want to search through. The first row of this range should contain the values you're searching for.
Row_index_num: This is the row number within the table_array from which you want to return a value. For example, if you want to retrieve a value from the second row of the table_array, you would enter 2 for this argument.
Range_lookup (optional): This argument can be either TRUE, FALSE, or omitted.
If you enter TRUE or omit this argument, HLOOKUP will look for an approximate match (closest match).
If you enter FALSE, HLOOKUP will look for an exact match.
Here's a step-by-step guide on how to use HLOOKUP in Excel:
Open your Excel spreadsheet and click on the cell where you want the result of the HLOOKUP to appear.
Type the HLOOKUP formula using the syntax mentioned above.
Example: If you want to find the salary of an employee named "John" in a table located in cells A1:D4 and the salary is in the second row of the table (row 2), you can use the following formula:
=HLOOKUP("John", A1:D4, 2, FALSE)
Press Enter, and Excel will execute the formula. If it finds a match for "John" in the first row of the table_array, it will return the corresponding value from the second row (in this case, John's salary).
Remember to adjust the cell references and arguments to match your specific Excel workbook and data. The HLOOKUP function is helpful for retrieving data from horizontal tables, such as salary lists, schedules, or other datasets organized horizontally.
Put Comment for quarry