DGET in WPS on Windows: Introduction

DGET in WPS on Windows is a database function for spreadsheet lookup and analysis; 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
Version limits	None stated	Available in WPS Spreadsheet
Membership limits	None for this function	You can use the function directly

About This Feature

Overview

The DGET function in WPS Spreadsheet is used to extract a single result from a data range that matches specified criteria. It is suitable for finding one matching record in a worksheet and returning the result directly to a target cell.

Core capabilities include:

Entering the DGET function and editing its arguments for everyday data lookup.
Viewing syntax prompts and argument requirements while building the formula.
Using cross-sheet references and nested calculations for more complex worksheets.
Updating results automatically after source data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local formula editing; internet access is needed for download, updates, or account sign-in
Other	WPS Office should be installed, and you should be able to open WPS Spreadsheet files

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation method	Download the Windows installer and complete the setup with the installation wizard
Post-install check	Open WPS Spreadsheet and type `=DGET(` in a cell to confirm that syntax guidance appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the DGET function in WPS Spreadsheet for returning a single matching value from a database-style range, with formula entry, syntax prompts, cross-sheet references, and recalculation support.	Excel provides the `DGET(database, field, criteria)` function to extract a single value from a list or database that matches specified conditions.	Google Sheets provides the `DGET(database, field, criteria)` function to return a single value from a table-like range using SQL-like criteria.	Notion provides a formula system based on properties, operators, and functions for database calculations, but it does not provide a spreadsheet-style DGET function.	Adobe Acrobat forms can use JavaScript for calculations, validation, and data handling in PDF forms, rather than spreadsheet database functions.
WPS Advantages	Advantage: You can enter DGET directly in WPS Spreadsheet and use syntax prompts during editing. Distinct: Cross-sheet references and automatic recalculation fit spreadsheet-based analysis workflows.	Compared with WPS: Excel also supports standard DGET syntax, with official guidance focused on syntax, criteria ranges, and error results such as `#VALUE!` and `#NUM!`.	Compared with WPS: Google Sheets also supports DGET and describes it as a SQL-like database query function in a table-like range.	Compared with WPS: Notion formulas are designed around database properties instead of direct cell-by-cell spreadsheet function entry.	Compared with WPS: Adobe focuses on PDF form scripting and calculation workflows instead of worksheet functions like DGET.
Official Source	—	DGET function	DGET	Formula syntax and functions	Using JavaScript in Forms

Overall Conclusion: If your main task is extracting one matching record inside a spreadsheet, WPS DGET, Microsoft Excel, and Google Sheets are the closest alternatives. Notion and Adobe support calculation workflows in different environments, so they fit different use cases from a worksheet-based DGET workflow.

Use Cases

No.	Scenario	Suitable For	Main Pain Point	How DGET Helps
1	Sales record lookup	Sales and operations teams	Need to return one result from a detailed table based on criteria	Use DGET to return the target field value from a matching record
2	Financial data verification	Finance staff	Need to locate one matching record in a database range	Use a criteria range with DGET to retrieve the result
3	Cross-sheet analysis	Data analysts	Manual consolidation across worksheets is inefficient	Use cross-sheet references in the formula
4	Dynamic report updates	Report maintainers	Results need to stay aligned with changing source data	Use automatic recalculation after data changes
5	Formula training	New users and trainers	Function arguments are not yet familiar	Use syntax prompts to understand the argument structure

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Writer, Spreadsheet, and Presentation core apps	✅ Available	✅ Available
DGET function usage	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
More advanced PDF and extended tools	Available within feature scope	More tools are available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Everyday spreadsheet lookup and learning DGET	Free	The DGET function itself is available directly for basic data work
Need more PDF tools, cloud storage, or broader office features	WPS Premium	Suitable for users who need a wider set of office capabilities

WPS membership center: Subscribe now