Excel: Finding Highest & Lowest Salaries by job title

Hi there I am trying to find a formula that will help complete the summary page in the example attached. I need to return the highest and lowest salaries by Job title. I tried VlookupMax and Min an...