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