DGET Google Sheet Formula

Generate Google Sheet DGET Formulas in seconds

Try Formula Generator View Examples

Interactive Formula Generator

Formula Generator

Create complex Google Sheets formulas with natural language. Simply describe what you want to calculate.

Upgrade to Sheet Alchemy Pro

Get advanced formulas, batch processing, and priority support

Upgrade Now

Input

Result

Your formula will be displayed here:

Your formula will appear here

Describe what you want to calculate and click Generate

Pro Features Available

Sheet Alchemy Pro includes additional advanced features to enhance your formula generation.

Advanced Formulas

Complex array formulas and dynamic ranges

Batch Processing

Generate multiple formulas at once

Unlimited History

Save and organize all your formulas

DGET Formula Syntax

=DGET(database, "Phone", criteria_range)

Example Use Case

Extracting a single value from a database that matches specific criteria

Understanding the DGET Formula

The DGET function in Excel extracts a single value from a database column when exactly one record matches the specified criteria. It's a precise database lookup tool—like finding a specific employee's phone number or a product's price based on unique identifiers.

DGET(database, "Phone", criteria_range) retrieves the phone number from the record that uniquely matches conditions defined in the criteria range. It takes database, field, and criteria arguments, applying strict filtering—and returns an error if either no matches or multiple matches are found.

Why Use DGET?

DGET enables precise single-value extraction—think unique record lookup or database validation. Its error handling for no matches (#VALUE!) or multiple matches (#NUM!) makes it valuable for ensuring data integrity in lookup operations or verifying unique constraints in datasets.

Example with Sample Data

Scenario	Formula	Result
Look up salary for employee ID E12345	=DGET(A1:F100, "Salary", G1:H2)	$72,500
Find price for product SKU ABC-123	=DGET(A1:F100, "Price", G4:H5)	$24.99
Retrieve status for order #10058	=DGET(A1:F100, "Status", G7:H8)	Shipped

DGET extracts single values: $72,500 salary for employee E12345, "Shipped" status for order #10058. If criteria match more than one record or none at all, DGET returns an error rather than potentially incorrect data. It's a precise database extractor.