writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 78:
Line 78: − +
→Examples
=DGET(A4:C10,"Name",C1:C2) : Returns 'Bob'
=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) : Returns '45' (Salary>8000, Age>32)
=DGET(A4:C10,2,C1:D2) : Returns '45' (Salary>8000, Age>32)