MATCH in WPS on Windows returns the relative position of a lookup value within a row or column range; 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 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
MATCH is a built-in lookup and reference function in WPS Spreadsheets. It finds a target value in a specified range and returns the relative position of that value. It is useful for data lookup, position-based matching, and combined formulas such as INDEX plus MATCH.
Core capabilities include:
- Insert the MATCH function from the Insert Function dialog.
- Type the MATCH formula directly in a cell or in the formula bar.
- Review syntax, arguments, and help information for the function.
Common use cases include list lookup, score range positioning, code matching, and dynamic references. MATCH returns a position number rather than the matched content itself.
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 entry; online help requires internet access |
| Other | You need to be able to open WPS Spreadsheets and edit worksheet cells |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Launch WPS Office, open a spreadsheet file, and confirm that the Formula tab includes the Insert Function entry |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Use MATCH in WPS Spreadsheets to return the relative position of a specified value in a range, either through Insert Function or direct formula entry. | Excel provides the MATCH function to return the relative position of a lookup value in a range and supports the match_type argument. | Google Sheets provides the MATCH function to return the relative position of a matched item and requires the search range to be one-dimensional. | In Notion formulas, match returns a list of regular-expression matches, so its logic differs from spreadsheet position lookup. | Acrobat forms can use JavaScript for calculations, validation, and field behavior, but they do not provide a worksheet MATCH function equivalent. |
| WPS Advantages | Advantage: Works directly in a spreadsheet cell workflow for position lookup and formula combinations. Distinct: Supports both Insert Function and direct formula entry for the same task. | Compared with WPS: It offers a similar function, while its documentation also points users to XMATCH for broader search directions and default exact matching. | Compared with WPS: It offers a similar function, but the official help states that the range must be one-dimensional; the desktop workflow differs from WPS. | Compared with WPS: It is more suitable for database properties and regex text processing than worksheet position lookup. | Compared with WPS: It is oriented toward PDF form scripting and field automation rather than spreadsheet formula entry. |
| Official Source | — | MATCH function | MATCH function | Formula syntax and functions | Using JavaScript in Forms |
Overall Conclusion
If your work focuses on spreadsheet position lookup and formula combinations, MATCH in WPS follows a familiar worksheet workflow and fits everyday data tasks well. Microsoft Excel and Google Sheets provide similar function coverage, while Notion and Adobe address different scenarios such as formula language processing or PDF form scripting.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How MATCH helps |
|---|---|---|---|---|
| 1 | Product code lookup | Operations and warehouse staff | Need to locate a code quickly in a list | Use MATCH to return the relative position of the code in a column |
| 2 | Score band positioning | Teachers and trainers | Need to locate the position of a score within a range table | Use MATCH with an ordered range table |
| 3 | Dynamic reference support | Finance and data analysts | Need to find a position before returning a related value | Use MATCH together with INDEX |
| 4 | Formula entry for daily work | General office users | Not familiar with function names or argument order | Use the Insert Function dialog to complete formula entry |
| 5 | Formula learning and troubleshooting | New users | Need help understanding syntax and arguments | Review the function help entry and argument descriptions |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| MATCH formula entry and calculation | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Additional advanced benefits | Available within the free scope shown on the product page | Available according to the benefits listed on the pricing page |
| Cloud storage | 1 GB | 20 GB, subject to the pricing page |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| Learning formulas and handling basic spreadsheet tasks | Free | The MATCH function itself is available for regular lookup and practice |
| Needing more cloud storage or broader office benefits | WPS Premium | Suitable when you also need more storage space and additional product benefits |
How to Subscribe
- WPS membership page: Subscribe now
Source: WPS Office pricing page