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.