Microsoft Excel HLOOKUP() Function

 The HLOOKUP() function in Microsoft Excel is used to search for a value in the first row of a range (table) and then return a value in the same column from a specified row. Here's how to use it:

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Let's break down each part of the HLOOKUP() function:

lookup_value: This is the value you want to find within the first row of the table.

table_array: This is the range of cells that contains the table where you want to search for the lookup value. 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 retrieve the value. For example, if you want to retrieve a value from the third row of the table_array, you would enter 3.

[range_lookup] (optional): This is a logical value that specifies whether you want an exact match or an approximate match. Enter FALSE for an exact match, and TRUE or omitted for an approximate match. If omitted, Excel assumes TRUE by default.

Here's an example:

Suppose you have a table of product information 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 first row (row 1) of the range A1:D3 and return the value from the third row (row 3), which corresponds to the price of the product. It ensures an exact match (FALSE) for the lookup. If the product ID is not found, the formula will return an error value.