XLOOKUP in WPS on Windows: Introduction

XLOOKUP in WPS helps you search a specified range and return the matched result in a formula field; 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

XLOOKUP is a formula function available in WPS multi-dimensional tables. It is used to search for a target value in a specified range and return the corresponding result. You can use it in a formula field and combine it with other functions for record matching, field backfilling, and conditional calculations.

Core capabilities include:

Entering an XLOOKUP formula in a formula field and getting results immediately.
Setting lookup ranges and return ranges with the function parameter format.
Combining XLOOKUP with functions such as IF and AND for more flexible data processing.

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 editing; internet access is needed for online help or synced data
Other	You need access to open the multi-dimensional table and permission to edit formula fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open a multi-dimensional table, and confirm that you can add a Formula field

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use XLOOKUP in a formula field inside a multi-dimensional table to search for matches, return corresponding values, and combine it with other functions.	Excel provides the XLOOKUP function for searching ranges or arrays, with exact match, approximate match, and search mode options.	Google Sheets provides the XLOOKUP function to find a match in a lookup range and return the corresponding value from a result range, with match_mode and search_mode support.	Notion databases support formulas, relations, and rollups for cross-database references and aggregation, but they do not provide a native spreadsheet XLOOKUP function.	Adobe Acrobat Sign provides calculated fields that update form values dynamically, but it does not provide a spreadsheet-style XLOOKUP function.
WPS Advantages	Advantage: You can complete lookup-and-return tasks directly in a formula field inside the same table. Distinct: It fits everyday table-based field linking and data filling workflows.	Compared with WPS: Excel documents a broader XLOOKUP syntax, including more explicit match and search mode options.	Compared with WPS: Google Sheets also documents a full XLOOKUP syntax and is oriented to browser-based spreadsheet workflows.	Compared with WPS: Notion is centered on database relations and rollups rather than cell-style lookup formulas in a spreadsheet grid.	Compared with WPS: Adobe calculated fields are designed for signing forms and field calculations, not spreadsheet lookup analysis.
Official Source	—	Excel XLOOKUP function	Google Sheets XLOOKUP function	Notion formula syntax Notion relations and rollups	Adobe calculated fields

Overall Conclusion
WPS XLOOKUP is a practical fit for lookup-and-return tasks inside multi-dimensional tables on Windows. If your work is centered on database relations or signing workflows, Notion and Adobe offer adjacent capabilities rather than the same spreadsheet-style function experience.

Use Cases

No.	Scenario	Suitable for	Main challenge	Solution
1	Record information backfill	Operations teams, sales teams	You need to return related information automatically by ID or key	Use XLOOKUP in a formula field to return the matched value
2	Conditional calculation chaining	Data organizers	You need to use lookup results in later logic or calculations	Nest XLOOKUP with IF, AND, and similar functions
3	Refresh after data import	Table maintainers	Results need to update after source data changes	Formula fields recalculate when the data changes

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
XLOOKUP function usage	Available	Available
Basic PDF features	Available	Available
Cloud storage	1 GB	20 GB
Advanced templates and more advanced tools	Limited	More items available

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
You mainly use XLOOKUP in multi-dimensional tables and need basic editing	Free	The function itself is available without membership
You need more cloud storage, more advanced tools, or multi-device collaboration	WPS Premium	It is a better fit when you also use broader premium capabilities

Membership page: Subscribe to WPS Premium