Changes

Jump to navigation Jump to search
65 bytes added ,  20:25, 17 April 2015
no edit summary
Line 82: Line 82:     
=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.
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|zJIAOt5BKYk|280|center|DGET}}
    
== See Also ==
 
== See Also ==
writer
2,661

edits

Navigation menu