INDIRECT in WPS on Windows: Introduction

INDIRECT in WPS is a spreadsheet reference function that returns a cell or range reference from text; this guide covers 1 core task, with 1 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	1	Matches the number of rows in the How-to Index
Available without membership	1	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

The INDIRECT function in WPS Spreadsheets converts a text reference into a usable cell or range reference. It is useful for dynamic references, cross-sheet lookups, and nested spreadsheet calculations on Windows.

Core capabilities include:

Enter =INDIRECT( in a cell or the formula bar and view syntax guidance.
Fill in the required arguments and return a calculation result.
Use cross-sheet references and nested calculations.
Recalculate results after related data changes.

Common use cases include dynamic reports, cross-sheet data retrieval, and reusable spreadsheet formulas. It helps reduce manual reference edits and makes complex formulas easier to reuse.

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 calculations
Other	You need access to a spreadsheet file and permission to edit formulas in cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, launch Spreadsheets, and confirm that you can enter `=INDIRECT(` in the formula bar

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheets, entering `=INDIRECT(` shows syntax guidance and supports argument entry, cross-sheet references, nested calculations, and recalculated results.	Microsoft Word supports formulas in table cells, including functions, bookmarks, and cell references, but the official page focuses on calculations inside document tables.	Google Sheets is presented as an online spreadsheet for managing, visualizing, and analyzing data, and Google highlights formula creation with Gemini in Sheets.	Notion formulas work with database properties, buttons, and automations for calculations and logic based on existing properties.	Adobe Acrobat supports calculations in PDF form fields for totals and linked form behavior.
WPS Advantages	Advantage: WPS fits spreadsheet-style dynamic reference work more directly, including cross-sheet references and nested calculations, with syntax guidance shown during formula entry.	Compared with WPS: the official Microsoft page describes formulas in Word tables rather than a full spreadsheet reference workflow.	Compared with WPS: Google emphasizes collaborative online spreadsheets and AI-assisted formula creation, while this WPS feature is documented as a direct spreadsheet function workflow.	Compared with WPS: Notion formulas are built around database properties instead of traditional spreadsheet cell references.	Compared with WPS: Acrobat calculations are designed for PDF form fields rather than spreadsheet cell references.
Official Source	—	Use a formula in a Word table	Google Sheets product page	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion
If your main task is building dynamic spreadsheet references, cross-sheet lookups, and nested formulas, INDIRECT in WPS is a practical fit for that workflow. Microsoft, Google, Notion, and Adobe also provide calculation features, but their official documentation highlights document tables, collaborative cloud spreadsheets, database properties, or PDF forms rather than this exact spreadsheet reference scenario.

Use Cases

No.	Scenario	Suitable For	Core Pain Point	How It Helps
1	Dynamic reporting	Finance and operations users	Report columns or ranges change often, so formulas need repeated edits	INDIRECT returns references from text and reduces manual updates
2	Cross-sheet lookups	Users maintaining multiple sheets	Data is spread across worksheets and reference paths are easy to mistype	INDIRECT can combine sheet names and cell addresses for lookups
3	Nested formula design	Advanced spreadsheet users	Complex formulas become harder to maintain as references grow	INDIRECT can be combined with other functions in nested calculations
4	Reusable spreadsheet templates	Template owners and team coordinators	The same template needs to switch reference targets across projects	Text-based references make templates easier to reuse
5	Result verification after updates	Daily analysts	Users need to confirm that results reflect changed source data	Recalculate and review the returned result after data changes

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
INDIRECT function entry and calculation	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Cloud storage	1 GB	20 GB
Template downloads	Limited	More advanced templates
AI tools	Limited access for some tools	Includes AI features with daily usage limits described on the pricing page

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Everyday spreadsheet calculations and learning functions	Free	It already supports core spreadsheet work and the INDIRECT function
More cloud storage, templates, and broader office features	WPS Premium	It is better suited to longer-term multi-file work and expanded feature needs

Subscribe here: Get WPS Premium