INDIRECT in WPS on Windows: Introduction

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

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	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 Spreadsheet on Windows converts a text reference into a usable cell or range reference for spreadsheet calculations. It supports formula entry with syntax prompts, flexible parameter input, cross-sheet references, nested calculations, and automatic recalculation when data changes.

Common use cases include dynamic cell references, pulling values from other worksheets, and combining text-based references with other formulas for data analysis. This helps reduce manual reference changes and keeps formulas more adaptable when worksheet content changes.

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 network connection is required for local formula editing; downloading, installation, and account-related actions require internet access
Other	You need to open a spreadsheet file and have permission to edit formulas in cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, open Spreadsheet, select a cell, and type `=INDIRECT(` to confirm that formula input is available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports INDIRECT formula entry, syntax prompts, cross-sheet references, nested calculations, and recalculation after data changes in WPS Spreadsheet.	Excel provides `INDIRECT(ref_text, [a1])` to return the reference specified by a text string, with A1 and R1C1 reference options.	Google Sheets provides `INDIRECT(cell_reference_as_string, [is_A1_notation])` to return a cell or area reference from a string.	Notion formulas support properties, operators, and functions for database calculations, but they do not provide a spreadsheet-style INDIRECT cell reference function.	Adobe Acrobat supports calculated form fields for PDF forms, focusing on form-field calculations rather than spreadsheet-style INDIRECT references.
WPS Advantages	Advantage: WPS keeps INDIRECT in a spreadsheet editing workflow with direct formula entry, syntax prompts, cross-sheet references, nested calculations, and recalculation in one place.	Compared with WPS: Microsoft documents A1 and R1C1 behavior in more detail and notes that external workbook references require the source workbook to stay open.	Compared with WPS: Google also supports string-based references and A1 or R1C1 notation, with a stronger focus on browser-based collaboration.	Compared with WPS: Notion formulas are designed for database properties and page data, so they are not a direct replacement for spreadsheet cell-reference formulas.	Compared with WPS: Adobe is better aligned with PDF form calculations and validation, not worksheet reference formulas.
Official Source	—	INDIRECT function	INDIRECT	Formula syntax and functions	Configure form field calculations in Acrobat

Overall Conclusion
If your main goal is to turn text into worksheet references, pull values across sheets, and build nested spreadsheet formulas, WPS INDIRECT fits everyday spreadsheet work well. Microsoft Excel and Google Sheets provide directly comparable INDIRECT functions, while Notion and Adobe focus on database formulas or PDF form calculations for different use cases.

Use Cases

No.	Scenario	Suitable For	Core Need	How WPS Helps
1	Switch references dynamically	Data organizers	Cell addresses need frequent updates	Build a text reference and return the target cell with INDIRECT
2	Pull values across worksheets	Finance and operations teams	Repeated cross-sheet lookups take time	Use worksheet names and cell addresses as text references in one formula
3	Build nested formulas	Advanced spreadsheet users	Complex formulas are hard to maintain	Combine INDIRECT with other functions to reduce hard-coded references
4	Recalculate after data changes	Report maintainers	Results must stay updated when source data changes	Keep the reference logic in INDIRECT so results update with the data
5	Learn and troubleshoot formulas	New users	Parameter rules and entry points are unclear	Enter the function in the formula bar and follow syntax prompts

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
INDIRECT formula entry and calculation	✅	✅
Cross-sheet references	✅	✅
Nested calculations	✅	✅
Automatic recalculation	✅	✅
Additional advanced benefits	Available within the free offering shown on the pricing page	More advanced benefits are available depending on the subscription plan

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Everyday learning and basic spreadsheet calculations	Free	The INDIRECT function itself can be used without membership for common reference calculations
Broader office work with more advanced benefits	WPS Premium	Suitable if you also need additional premium office capabilities beyond spreadsheet formulas

WPS membership center: Subscribe now