DGET in WPS Spreadsheet is a built-in database function for returning a single matching value based on criteria; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
| Version requirement | No specific threshold stated | The current materials do not list a version gate |
About This Feature
Overview
DGET is a database function in WPS Spreadsheet. It returns a single value from a target column when the specified criteria match one record in a database range. It is useful when you need to retrieve one exact result from a table with headers, and it can also be inserted through the function dialog for easier parameter review.
Core tasks include:
- Insert DGET from the Insert Function dialog.
- Type
=DGET(database, field, criteria)directly in a cell or in the formula bar. - Review syntax, parameter descriptions, and help information when checking formula input.
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 | A network connection is not required for local formula entry, but it is needed for online help pages or downloads |
| Other | You need access to WPS Spreadsheet and a worksheet that includes a header row, a database range, and a criteria range |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Launch WPS Office, open a spreadsheet file, and confirm that the Formula tab and Insert Function entry are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports DGET in spreadsheets to return a single matching value from a database range based on criteria, and lets you review parameters in the function dialog. | Excel provides DGET(database, field, criteria) to extract a single value from a column in a list or database that matches specified conditions. | Google Sheets provides DGET(database, field, criteria) to return a single value from a database table-like array or range using a SQL-like query. | Notion formulas support properties, logic, text, number, and date calculations, but its help content does not describe a spreadsheet-style DGET function. | Acrobat focuses on PDF form calculations such as sums and products for form fields, rather than spreadsheet database functions like DGET. |
| WPS Advantages | Advantage: DGET can be entered directly in worksheet cells or inserted from the function dialog, which is practical for spreadsheet lookup tasks and parameter checking in one place. | Compared with WPS: Excel offers a similar DGET function and its official page explicitly documents #VALUE! and #NUM! error cases. | Compared with WPS: Google Sheets also supports DGET and describes it as a SQL-like query over a table-like array or range. | Compared with WPS: Notion is oriented toward database properties and formula fields instead of a traditional worksheet function-entry workflow. | Compared with WPS: Acrobat is oriented toward PDF form field calculations instead of worksheet-based database retrieval. |
| Official Source | — | DGET function | DGET | Formula syntax and functions | Configure form field calculations in Acrobat |
Overall Conclusion: WPS, Microsoft Excel, and Google Sheets all support DGET-style database retrieval in spreadsheet workflows. Notion and Adobe Acrobat support calculation features in different product contexts, so they are better suited to database-property logic or PDF form processing rather than worksheet database functions.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How DGET helps |
|---|---|---|---|---|
| 1 | Retrieve one result by criteria | Finance, operations, and administrative users | Large tables take time to check manually | Use DGET to return one matching value from a target column |
| 2 | Learn database functions for the first time | Students and new office users | Parameter meaning and order may be unclear | Use the Insert Function dialog to review parameter descriptions while entering the formula |
| 3 | Check unexpected formula results | Users who work with reports often | It can be hard to locate the cause of an error quickly | Review syntax and verify the database range, field, and criteria range |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| DGET formula entry and calculation | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Some advanced value-added features | Depends on the specific feature | Includes more value-added capabilities |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| Daily use of DGET and other basic spreadsheet functions | Free version | The current materials do not show a membership requirement for DGET |
| Users who also need more value-added office features | WPS Premium | Suitable when you need broader benefits such as additional tools or expanded service coverage |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page