VLOOKUP and HLOOKUP are both used to locate and ... This time, we have three things to work out: the sum of the salaries over ...