WPS Features
Resources
Free AI Tools
Docs Center

How to Use the LOOKUP Function in WPS on Windows

Last updated:July 13, 2026

Use LOOKUP through 3 how-to topics: entering it from the Insert Function dialog, typing the formula directly in a cell, and reviewing syntax and parameter details; 3 topics are free and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Enter LOOKUP from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review syntax and parameter detailsFree

How-to Guide

1. Enter LOOKUP from the Insert Function dialog

Entry point: 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 LOOKUP in the dialog box.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog box.
  6. Click OK to finish entering the function.

Success Criteria

  • The selected cell now contains a LOOKUP formula.
  • The result appears in the cell after the parameter dialog closes.
  • You can continue editing, copying, or filling the formula.

Tips While Using

  • Confirm that the lookup range and return range match correctly before entering parameters.
  • If the result is unexpected, check the referenced range and data format.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =LOOKUP(...) directly in the cell or formula bar.
  3. Press Enter to confirm.
  4. If you want to review parameter details, type =LOOKUP( and press F1 to open syntax help.

Success Criteria

  • The LOOKUP formula has been entered in the cell.
  • Pressing Enter returns a result or keeps the formula structure in place.
  • You can review and edit the formula again in the formula bar.

Tips While Using

  • Keep the parameter separators correct.
  • Check parentheses, commas, and referenced ranges carefully during manual entry.

3. Review syntax and parameter details

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Type LOOKUP in the search box.
  3. Select the function to review its syntax and parameter structure.
  4. Open the related help entry for more details if needed.

Success Criteria

  • The LOOKUP function information view is open.
  • You can review the function name, parameter order, and basic description.
  • You can use that information to continue entering or editing the formula.

Tips While Using

  • Focus on parameter order and referenced ranges when reviewing the description.
  • If a formula already exists in the worksheet, compare it with the function details item by item.