MATCH in WPS on Windows: Introduction

WPS MATCH is a lookup-position function in Spreadsheets; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the how-to index
Available without membership	3	All listed tasks can be used directly
Membership-related items	0	The workflows in this guide do not require membership
Version scope	No version restriction	Available in WPS Spreadsheets on Windows

About This Feature

Overview

MATCH is a built-in function in WPS Office for Windows Spreadsheets. It returns the relative position of a target value within a single-row or single-column range. It supports quick insertion, flexible parameters, cross-sheet references, nested calculations, and automatic recalculation when data changes.

You can use it to:

enter the MATCH function and view syntax prompts;
return the relative position of a target value based on the selected arguments;
use MATCH inside cross-sheet or nested formulas.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office
App environment	WPS Office installed with access to Spreadsheets
Network	Internet is recommended for download, installation, and account services; local formula calculation can usually be completed offline
File access	An editable spreadsheet file and permission to edit cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open Spreadsheets and type `=MATCH(` in a cell to start editing the function

Source: WPS Download Center

Compare with Alternatives

Comparison Item	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the MATCH function to return the relative position of a matched value in a range, with support for cross-sheet references and nested calculations.	The official Microsoft Learn page for Word describes Find.Execute for text find and replace, not a spreadsheet MATCH function.	Google Sheets provides the MATCH function to return the relative position of an item in a one-dimensional range, with `search_type` rules.	Notion formulas include functions such as `match`, `find`, and `findIndex`, mainly for text, list, or database-property calculations.	Acrobat focuses on searching text in PDFs and across multiple PDF files, not spreadsheet MATCH formulas.
WPS Advantages	Advantage: works directly in a spreadsheet formula workflow and fits position lookup together with other spreadsheet functions.	Compared with WPS, this official page focuses on document text search rather than spreadsheet position formulas.	Compared with WPS, the function goal is similar and both are suitable for position lookup in spreadsheets.	Compared with WPS, the official capability is more oriented to database formulas and text-processing scenarios.	Compared with WPS, the official capability is centered on PDF content search rather than spreadsheet formula calculation.
Official Source	—	Find.Execute method	MATCH function	Formula syntax & functions	Searching in PDFs

Overall Conclusion: If your main task is position lookup and formula-based analysis in spreadsheets, WPS MATCH is a direct fit for that workflow. Google Sheets offers a similar spreadsheet function, while Notion and Adobe focus on different content-processing scenarios.

Use Cases

No.	Scenario	Suitable for	Common need	How MATCH helps
1	Find the position of an ID or code	Data entry staff	Quickly confirm where a value appears in a list	MATCH returns the relative position in the selected range
2	Combine lookup position with other formulas	Spreadsheet analysts	A keyword is known, but the row or column position is not	MATCH can be combined with other functions after locating the position
3	Locate data across sheets	Collaborative office users	Data is spread across multiple worksheets	MATCH can reference ranges from other sheets
4	Work with changing data	Report maintainers	Positions need to stay current after data updates	Automatic recalculation helps refresh results
5	Learn function arguments	New users	Argument order and input format are not yet familiar	Syntax prompts help complete the formula correctly

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Enter and calculate MATCH formulas	Available	Available
Basic spreadsheet editing	Available	Available
Advanced PDF editing and conversion	Limited	More advanced tools available
Template downloads	Limited	More template benefits available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Learning MATCH and handling basic spreadsheet calculations	Free	MATCH itself is available directly, so it is suitable for everyday formula practice
Needing more templates, cloud storage, or additional office tools	WPS Premium	Better suited to users who want broader office features

Visit the WPS Office pricing page to review available plans.