Changes

=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)  : Returns '45' (Salary>8000, Age>32)

=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,"Salary",A1:A3)  : Returns '#N/A' error message.

=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.

== See Also ==

== See Also ==