DGET in WPS on Windows: Introduction

DGET in WPS is a database lookup function in WPS Sheets; it includes 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
Version limits	None	Available in WPS Sheets across supported versions

About This Feature

Overview

DGET is a function in WPS Office for Windows Sheets that extracts a single matching value from a data range based on specified criteria. It is useful for spreadsheet data calculation and analysis.

Core capabilities include:

Enter the DGET function quickly and use syntax prompts to start building a formula.
Retrieve values by criteria for common database-style lookup tasks.
Use cross-sheet references and nested formulas for more complex calculations.
Keep results updated automatically when source data changes.

System Requirements

Item	Requirement
OS	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended; DGET is available in WPS Sheets
Network	No required internet connection for local formula calculation; internet is needed for download, updates, and account-related actions
Other	WPS Office must be installed, and you need an editable spreadsheet file

Download & Installation

Before using the DGET function, install WPS Office for Windows and open WPS Sheets.

Item	Notes
Official Download	WPS Office Free Download
Post-install Check	Launch WPS Office → open WPS Sheets → select a cell and type `=DGET(` to confirm that formula input and calculation are available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Sheets, you can enter `=DGET(` to use the function with syntax prompts, cross-sheet references, nested calculations, and automatic recalculation.	Excel provides `DGET(database, field, criteria)` to extract a single value from a list or database column that matches specified conditions.	Google Sheets provides `DGET(database, field, criteria)` to return a single value from a table-like array or range using an SQL-like query.	Notion formulas can calculate values from database properties, but they are not spreadsheet DGET database functions.	Acrobat can configure calculations for PDF form fields, which supports form-based calculations rather than spreadsheet database functions.
WPS Advantages	Advantage: WPS lets you use DGET directly in a Windows spreadsheet workflow with syntax prompts, cross-sheet references, nested formulas, and automatic recalculation.	Compared with WPS: Excel also supports standard DGET syntax and documents syntax, criteria rules, and error returns such as `#VALUE!` and `#NUM!`.	Compared with WPS: Google Sheets also supports DGET, with documentation focused on table-like ranges and SQL-like query behavior.	Compared with WPS: Notion is better suited to database property formulas across records, not cell-based spreadsheet function workflows.	Compared with WPS: Adobe focuses on PDF form field calculations instead of worksheet-based database lookup formulas.
Official Source	—	DGET function	DGET	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion
If your work centers on spreadsheet lookups, nested formulas, and recalculating results on Windows, DGET in WPS fits naturally into everyday spreadsheet tasks. Microsoft Excel and Google Sheets offer comparable DGET syntax, while Notion and Adobe focus on database-property formulas or PDF form calculations.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Extracting a single record by criteria	Data coordinators	Need to return one result from a data table based on conditions	Use DGET to return the target field value by criteria
2	Looking up results across sheets	Finance and operations staff	Data is spread across multiple worksheets, so manual lookup is slow	Reference ranges from other sheets in the formula
3	Building combined formula logic	Advanced spreadsheet users	A single function is not enough for more complex analysis	Nest DGET with other functions
4	Reviewing dynamic results	Report maintenance staff	Results need to stay aligned after source data changes	Use automatic recalculation to keep results updated

Membership & Benefits

This section covers 3 membership topics so you can review free access, membership differences, and subscription options.

Free vs WPS Premium

Feature	Free User	WPS Member
DGET function usage	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Additional advanced benefits	Available within the free scope shown on the product page	Available according to the benefits listed for the selected plan

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Everyday DGET use and basic spreadsheet calculation	Free	The source content shows no membership restriction for this function
Additional PDF, template, cloud storage, or other extended benefits	WPS Member	You can review the matching plan benefits on the pricing page

WPS membership center: Subscribe now