# HLOOKUP Function in Excel

A free Office suite fully compatible with Microsoft Office

A free Office suite fully compatible with Microsoft Office

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

· **Description:**

The HLOOKUP function can look up a value in the top row of values and returns a value in the same column from a row that you specify.

· **Syntax: **

HLOOKUP(lookup_value, table_array, row_num, range_lookup)

· **Arguments:**

**L****ookup_****value**

The value to be found in the first row of the table. (can be a value, a reference, or a text string).

**T****able_array**

The table of text, numbers, or logical values, in which data is looked up. (can be a reference or a range name)

**R****ow_num**

The row number in table_array from which the matching value should be returned.

**Range_lookup**

Enter FALSE to find an exact match. Enter TRUE to find an approximate match. If this parameter is omitted, TRUE is the default.

· **Example:**

Assume that we want to find John's marks in math using the HLOOKUP Function.

1. Open your table in WPS Spreadsheet, click cell B8

2. Head to the **Formulas** tab > **Insert Function** > enter **HLOOKUP** in the edit box.

In the pop-up box, we want to insert the **HLOOKUP** function.

1) **L****ookup_****value** is the value to be found in the first row of the table, in this case, John is the value we want to look up. So let's put John at Lookup_value.

2) **T****able_array** is the table of text, numbers, or logical values, in which data is looked up. A1:H4 is the area that contains all the data, so let's put A1:H4 at **L****ookup_****value****.**

3) **R****ow_num**is the row number in table_array from which the matching value should be returned. 3 is the row number where John's math score can be found, so let's put 3 at** R****ow_num****.**

4) **Range_lookup** connects FALSE to exact match, we want an exact match for the score, so False will be the last argument.

So, we enter John at **lookup_****value**, A1:H4 at** table_array****,** and 3 at **row_num, **False at **Range_lookup. **

Finally, we can get a 72 as John's math mark.

Was this helpful?

Yes

No

Trending Tutorials

- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to add text to beginning or end of all cells in Excel
- 6. How to compare two excel sheets and highlight differences