MATCH in WPS on Windows: Introduction

WPS MATCH is a spreadsheet lookup function for finding positions in a range; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Version scope	No version restriction	Available in WPS Spreadsheet on Windows

About This Feature

Overview

MATCH is a built-in function in WPS Spreadsheet on Windows. It is used to find the position of a specified value in a one-dimensional range and return its relative index. It is useful for data lookup, conditional positioning, dynamic references, and nested formulas.

Core capabilities include:

Enter the MATCH function quickly for position-based lookup.
Follow syntax prompts while filling in arguments.
Use cross-sheet references and nested formulas.
Recalculate results automatically after source data changes.

Common use cases include score ranking, item code matching, dynamic lookup helpers, and combining MATCH with INDEX to return a target value.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account-related actions
Other	You need to be able to open WPS Spreadsheet files and edit cells and formulas

Download & Installation

Before using the MATCH function, install WPS Office on your Windows device and open WPS Spreadsheet.

Item	Details
Official download	WPS Office Free Download
Post-installation check	Launch WPS Office → open WPS Spreadsheet → select any cell and enter `=MATCH(` in the formula bar

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the MATCH function in WPS Spreadsheet, with formula-bar entry, syntax prompts, cross-sheet references, nested calculations, and automatic recalculation.	Excel provides the MATCH function to search for an item in a range and return its relative position, with `-1`, `0`, and `1` match types.	Google Sheets provides the MATCH function to return the relative position of an item in a one-dimensional range; if the range is not one-dimensional, it returns `#N/A!`.	Notion provides database formulas and a formula editor for properties, built-ins, and functions, but its official formula documentation does not describe a spreadsheet-style MATCH function equivalent.	Adobe Acrobat provides calculation setup for PDF form fields and form workflows, rather than spreadsheet functions such as MATCH.
WPS Advantages	Advantage: WPS supports a direct spreadsheet workflow for entering MATCH in the formula bar, following syntax prompts, using cross-sheet references, and recalculating when data changes.	Compared with WPS: Excel also supports MATCH and documents the same match-type pattern, while also suggesting XMATCH as a newer option.	Compared with WPS: Google Sheets also supports MATCH, but its documentation specifically requires a one-dimensional range; WPS feature guidance also covers cross-sheet references and nested use.	Compared with WPS: Notion focuses on database property formulas and formula editing instead of a cell-based spreadsheet MATCH workflow.	Compared with WPS: Adobe focuses on PDF form calculations and field logic instead of spreadsheet lookup functions.
Official Source	—	MATCH function	MATCH function	Intro to formulas	Advanced form fields

Overall Conclusion: If your main task is position lookup inside spreadsheets, WPS MATCH fits everyday worksheet work well. Microsoft Excel and Google Sheets provide comparable MATCH behavior, while Notion and Adobe focus on database formulas or PDF form calculations rather than spreadsheet lookup formulas.

Use Cases

No.	Scenario	Suitable for	Core need	How MATCH helps
1	Score position lookup	Teachers and academic staff	Quickly identify where a score appears in a list	Use MATCH to return the relative position of the target value in the score range
2	Product code matching	Operations and warehouse teams	Manual lookup is slow in long lists	Use MATCH in the code column to locate the row position of a target code
3	Dynamic lookup support	Finance and data analysts	A lookup position is needed before returning another value	Combine MATCH with INDEX and similar formulas
4	Cross-sheet references	General office users	Data is split across multiple worksheets	Use cross-sheet references with MATCH to locate positions across sheets
5	Ongoing report updates	Report maintainers	Results need to stay aligned with changing data	Use automatic recalculation so MATCH updates with source data

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Enter and calculate MATCH formulas	✅ Available	✅ Available
Formula syntax prompts	✅ Available	✅ Available
Cross-sheet references and nested calculations	✅ Available	✅ Available
Additional premium benefits	Refer to the current account benefits page	More benefits may be included depending on the subscription plan

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday spreadsheet lookup and formula learning	Free	The MATCH function itself does not require membership for basic lookup tasks
Broader cross-device or added office benefits	WPS Premium	Suitable if you also need additional subscription benefits shown on the pricing page

WPS membership center: Subscribe now