WPS Features
Resources
Free AI Tools
Docs Center

How to Use the HLOOKUP Function in WPS on Windows

Last updated:July 13, 2026

Use HLOOKUP through 3 how-to topics, all available without membership, and jump to the right section from the How-to Index.

How-to Index

No.TopicMembership
11. Insert HLOOKUP from the Insert Function dialogFree
22. Type an HLOOKUP formula directly in a cellFree
33. Review HLOOKUP syntax and parametersFree

How-to Guide

1. Insert HLOOKUP from the Insert Function dialog

Entry: Formula tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
  3. Search for HLOOKUP in the dialog box.
  4. Select the function and click OK.
  5. Enter the required parameters in the Function Arguments dialog.
  6. Click OK to insert the formula.

Success Criteria

  • Interface result: The target cell now contains an HLOOKUP formula.
  • What you can do next: You can continue editing parameters, press Enter to confirm, or copy the formula to other cells.

Tips While Using

  • You can search with either uppercase or lowercase HLOOKUP.
  • Make sure the first row of the selected range contains the value you want to search for.

2. Type an HLOOKUP formula directly in a cell

Entry: Cell or formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =HLOOKUP(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm the formula.
  4. If needed, start with =HLOOKUP( and then complete the parameters step by step.

Success Criteria

  • Interface result: The cell shows the calculated result, and the formula bar keeps the full formula.
  • What you can do next: You can drag the fill handle to copy the formula or adjust the referenced range.

Tips While Using

  • Use English commas to separate parameters.
  • When copying the formula, check whether relative and absolute references match your intended result.

3. Review HLOOKUP syntax and parameters

Entry: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter HLOOKUP in the search box.
  3. Select the function to review its syntax and parameter details.
  4. Check the lookup value, range, return row number, and match mode before confirming the formula.

Success Criteria

  • Interface result: You can see the HLOOKUP function name, syntax structure, and parameter descriptions.
  • What you can do next: You can move on to parameter entry and complete the formula insertion.

Tips While Using

  • Confirm that the return row number is within the selected range.
  • Approximate match and exact match behave differently, so verify the data structure before entering the formula.