How to Use the MATCH Function in WPS on Windows

Last updated:July 17, 2026

Use MATCH through 3 indexed tasks, with 3 free tasks and 0 membership-related items, so you can jump directly to the workflow you need.

How-to Index

No.TaskAccess
11. Enter the MATCH functionFree
22. Complete the arguments for a MATCH calculationFree
33. Use MATCH in cross-sheet or nested formulasFree

How-to Guide

1. Enter the MATCH function

Entry point: Formula tab → formula bar

  1. Open Spreadsheets and select the cell where you want to enter the formula.
  2. Type = to start formula editing.
  3. Type MATCH(.
  4. Review the syntax prompt and argument hint that appears.

Success Check

  • The cell or formula bar enters function-editing mode.
  • You can continue entering the lookup value, lookup range, and match type.

Notes

  • If = is not entered first, the content may be treated as plain text.
  • The worksheet needs to be editable.

2. Complete the arguments for a MATCH calculation

Entry point: target cell → formula bar

  1. After MATCH(, enter the value you want to find.
  2. Enter the separator, then select a single-row or single-column lookup range.
  3. Enter the match type argument as needed.
  4. Type the closing parenthesis and press Enter.

Success Check

  • The cell shows the returned position or an error message for further review.
  • You can copy the formula, adjust arguments, or combine it with other functions.

Notes

  • If the lookup range is not a single row or single column, the result may not match your expectation.
  • Incorrect parentheses or separators can cause a formula error.

3. Use MATCH in cross-sheet or nested formulas

Entry point: Formula tab → formula bar

  1. Enter a formula that includes MATCH in the target cell.
  2. Replace the lookup range with a reference from another worksheet, or use MATCH as an argument inside another function.
  3. Check the reference relationship and argument order.
  4. Press Enter and confirm that the result updates correctly.

Success Check

  • The formula returns a position result, or MATCH works correctly as part of a nested formula.
  • When data changes, the result can recalculate automatically.

Notes

  • An incorrect cross-sheet reference can cause unexpected results.
  • In nested formulas, check parentheses carefully in the formula bar.