Returning max value from vector result based on lookup function

Hi Im trying to return the maximum value from one column based on the value in a second equalling a specific value in a third (actually a separate sheet) Sheet 1 LocationInfo       Sheet 2...