==DGET(database,field,criteria)
=DGET(A5:E11, "Yield", A1:F3)
Let's say that we have a table of data (A5:E11) that contains a column for Yield. We want to find the value for Yield that meets certain conditions that are given in A1:F3. We can use the DGET function to do this.This function will return 10, because it is the only record that meets the conditions in A1:F3.
=DGET(A5:E11, "Yield", A1:F3, 6, 9)
Using the same example as above, let's say that we want to find the value for Yield that meets certain conditions in A1:F3, but this time we want to limit the search to the rows 6-9 of the table (A5:E11). We can use the DGET function to do this by adding an optional parameter to the formula.This function will return 10, because it is the only record that meets the conditions in A1:F3 within the given row range.
=SUM(DGET(A5:E11, "Yield", A1:F3))
Using the same example as above, let's say that we want to find the sum of the Yield values for all records that meet certain conditions in A1:F3. We can use the DGET function to do this by adding the SUM function to the formula.
The DGET function is a useful tool for retrieving a single value from a list or database by specifying certain conditions. It is a helpful way to quickly extract data.