DGET Function

The DGET function returns a single result from a table/database range, based on the given conditions.

Formula:


=DGET(Database Range, Field Name, Criteria Range)
Whereas Database Range is the entire table/database (including the title), Field Name is the field for which the count has to be taken and Criteria Range is the name of the Field Name.

Video Tutorial:


Let us extract a particular item from table/database, using DGET function, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question