WPS Find Reference Field on Windows: Introduction

WPS Find Reference Field is a cross-table reference field for smart spreadsheet data 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	No version limit	Use it in the currently available version

About This Feature

Overview

Find Reference Field is a field type in WPS smart spreadsheet data tables. It lets you use a related field to pull the value of a target field from another data table, so related information can be shown across tables.

Core capabilities include:

Create a Find Reference Field: add a new field from the right side of the table header and set the field type to Find Reference.
Configure field settings: choose the related field, target field, and lookup conditions to control how referenced results are shown.

This feature works well for linking orders with product details, syncing related record content, and preparing connected data across tables. After the field is created, you can still adjust its settings later.

System Requirements

Item	Requirement
Operating system	A Windows PC 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 table work; for online sync, keep a stable connection
Other	You need access to a smart spreadsheet data table and permission to edit fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter a smart spreadsheet data table, and confirm that the add-field entry is available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In smart spreadsheet data tables, WPS can use a related field to automatically pull a target field value from another table and lets you set lookup conditions in field settings.	Microsoft Lists lookup columns can show values from a source list and can also display additional source columns for related list data.	Google Sheets can reference data from other sheets in the same spreadsheet, and can use IMPORTRANGE to pull ranges from other spreadsheets.	Notion databases use Relation to connect databases and Rollup to pull or aggregate properties from related database entries.	Adobe Acrobat supports advanced form fields and calculations for PDF forms, but it does not provide a native table-to-table lookup structure like a spreadsheet data table.
WPS Advantages	Advantage: WPS provides cross-table reference as a direct field type. Distinct: after the field is created, you can continue adjusting the related field, target field, and lookup conditions in field settings.	Compared with WPS: Microsoft focuses on list relationships and lookup columns inside Microsoft Lists.	Compared with WPS: Google often relies on formulas or cross-sheet references to organize returned results.	Compared with WPS: Notion uses database relations and rollups, which fit connected database pages more than a field-style table entry.	Compared with WPS: Adobe focuses on PDF form calculations rather than structured cross-table references in data tables.
Official Source	—	Create list relationships by using lookup columns	Reference data from other sheets	Relations & rollups	Advanced form fields

Overall Conclusion
Find Reference Field is a practical choice when you want to build cross-table field mapping directly inside a data table. If your work centers on field setup and ongoing table maintenance, WPS offers a more direct entry. If your main workflow is based on lists, formulas, database pages, or PDF forms, the native approach in those products may fit better.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Link orders with product details	Operations teams, sales support	Order tables often need product fields without repeated manual entry	Create a Find Reference Field and pull target fields from the product table through a related field
2	Sync customer and contact details	Customer management staff	Information is spread across multiple tables and is hard to keep aligned	Configure a Find Reference Field to show related record content automatically
3	Summarize project and member data	Project coordinators	Project tables need quick access to member details from another table	Use field settings to choose target fields and lookup conditions for centralized display
4	Maintain shared base data	Data maintenance staff	The same information is updated in multiple tables and can become inconsistent	Keep base data in a related table and show it through a Find Reference Field
5	Prepare connected data before analysis	Analysts	Related fields often need to be completed before later analysis	Build the Find Reference Field first, then continue with later analysis or combined workflows

Membership & Benefits

Free vs WPS Premium

The feature description shows that Find Reference Field has no membership restriction. The WPS pricing page also presents both free and paid plans for broader office needs.

Capability	Free users	WPS Premium
Basic use of Find Reference Field	✅ Available	✅ Available
Advanced PDF tools	Some features available	More advanced features available
Cloud storage and sharing plans	Basic quota	Higher quota or multi-user plans
AI and advanced office features	Some limits apply	More related capabilities are available

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
You only need to create and configure Find Reference Fields in data tables	Free plan	This feature itself has no membership restriction
You also need more PDF, cloud, or AI office capabilities	WPS Premium	Suitable when your work goes beyond this field feature and needs broader office tools

WPS membership center: Subscribe now