WPS Find Reference Field on Windows: Introduction

WPS Find Reference Field is a cross-table reference feature in WPS tables; it includes 2 core tasks, with 2 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	2	Matches the number of rows in the How-to Index
Available without membership	2	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Version limit	None stated	Use the feature from the current entry point

About This Feature

Overview

Find Reference Field is a field type in WPS tables on Windows. It uses a linked field to pull the value of a target field from a related data table, so related information can be shown across tables automatically.

Core tasks include:

Create a Find Reference Field: add a new field from the table header and name it.
Configure field properties: choose the linked field, target field, and lookup conditions to control the displayed result.

This feature is useful for order and product summaries, synchronized related records, and cross-table information display. After the field is created, you can still adjust its settings later.

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	A network connection is recommended when opening online tables or syncing data
Other	You need access to the related table and the required editing permission

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter the table, and confirm that Find Reference appears in the field type list

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Uses a linked field to automatically display the value of a target field from a related data table for cross-table display.	Microsoft Lists lookup columns automatically show information from a source list in a target list and can display multiple source columns.	Google Sheets can reference data from other sheets in the same spreadsheet and use IMPORTRANGE for another spreadsheet.	Notion relations connect databases, and rollups pull selected properties into another database.	Adobe Acrobat supports advanced form fields and calculations, with a focus on PDF forms rather than table-style cross-table lookup.
WPS Advantages	Advantage: WPS keeps linked field, target field, and lookup condition setup in one field configuration flow, which fits structured table data maintenance.	Compared with WPS: focuses more on list relationships and lookup column display settings.	Compared with WPS: relies more on formulas or sheet references entered in cells.	Compared with WPS: focuses more on database relations and rollup properties.	Compared with WPS: focuses more on PDF form fields and calculation workflows.
Official Source	—	Lookup columns in Microsoft Lists	Reference data from other sheets	Relation and rollup properties	Advanced form fields in Acrobat

Overall Conclusion
Find Reference Field works well when you need related data to appear directly inside a WPS table through field-level setup. Compared with list relationships, cell formulas, or database rollups, it keeps the workflow closer to table field configuration and ongoing data maintenance.

Use Cases

No.	Scenario	Suitable for	Main issue	Solution
1	Link orders with product details	Operations teams, sales support	Order tables need repeated product information	Use Find Reference Field to pull target values from a product table
2	Sync customer records	Service teams, coordinators	Customer information needs to stay aligned across tables	Reference values from a main customer table through a linked field
3	Connect project and task data	Project managers, executors	Task tables need key project attributes	Show related project values through the target field
4	Display summary data across tables	Data organizers	Users need to check another table manually	Show the selected field directly in the current table
5	Adjust field rules later	Table admins	Lookup rules may need updates after creation	Reopen field settings and change the referenced field or conditions

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic creation and setup of Find Reference Field	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Advanced PDF editing and broader extra tools	Limited	✅ More tools available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You only need to create and configure Find Reference Field in tables	Free	The feature information shows no membership restriction
You also need broader PDF tools, more cloud storage, or sharing features	WPS Premium	Better suited to broader office needs beyond this table feature

WPS membership page: Subscribe now