Microsoft Excel HLOOKUP() Function

 To use Microsoft Excel's HLOOKUP() function, which searches for a value in the top row of a table and returns a value in the same column from a specified row, follow these steps:

Open Excel: Launch Excel and open the worksheet containing the data you want to work with.

Select a cell: Click on the cell where you want the result of the HLOOKUP() function to appear.

Type the function: In the selected cell, type =HLOOKUP( to start the function.

Enter the lookup value: After typing =HLOOKUP(, enter the value you want to search for. This is the value you want to find in the top row of your table.

Specify the table array: After entering the lookup value, specify the range of cells that contains the table you want to search. This should include the row where you want to find the lookup value and the rows where you want to return the result.

Enter the row index number: After specifying the table array, enter the index number of the row from which you want to return the result. This is the row number relative to the top row in your table array. For example, if you want to return a value from the third row of your table array, you would enter 3.

Specify the range lookup (optional): If you want an exact match, enter FALSE or 0. If you want an approximate match, enter TRUE or 1. If you omit this argument, Excel will default to TRUE for an approximate match.

Close the function: Close the parentheses ) to complete the function.

Press Enter: After closing the parentheses, press Enter to execute the function. The result will appear in the selected cell, showing the value found in the specified row of the table array corresponding to the lookup value.

Here's an example:

Suppose you have a table of product data in cells A1 to D3, where row 1 contains product IDs, row 2 contains product names, and row 3 contains their prices. You want to find the price of the product with ID "P001".

=HLOOKUP("P001", A1:D3, 3, FALSE)

This formula will search for the value "P001" in the top row (row 1) of the table array A1:D3 and return the value from the third row (row 3), which corresponds to the price of the product with ID "P001"