writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 80:
Line 80: − +
→Examples
=DGET(A4:C10,"Name",C1:C2) : Extracts a single value from Name column in the range A4 to C10, for the cells with Salary>8000. ''Returns 'Bob''' as a result.
=DGET(A4:C10,"Name",C1:C2) : Extracts a single value from Name column in the range A4 to C10, for the cells with Salary>8000. ''Returns 'Bob''' as a result.
=DGET(A4:C10,2,C1:D2) : Extracts a single value second column (Age) in the range A4 to C10, for the cells with Salary>8000 and Age>32. ''Returns '45''' as a result.
=DGET(A4:C10,2,C1:D2) : Extracts a single value from the second column (Age) in the range A4 to C10, for the cells with Salary>8000 and Age>32. ''Returns '45''' as a result.
=DGET(A4:C10,"Salary",A1:A3) : Extracts a single value from Salary column in the range A4 to C10, for all cells from the Name column. ''Returns '#N/A''' error message as there are more than one matching results.
=DGET(A4:C10,"Salary",A1:A3) : Extracts a single value from Salary column in the range A4 to C10, for all cells from the Name column. ''Returns '#N/A''' error message as there are more than one matching results.