I need a formula to obtain the minimum wage for a specific job title that
are listed in a row. For instance I have the following information:

A B C

Foreman 17.50
Foreman 18.00
Asst. Foreman 15.00
Asst. Foreman 14.50
Welder 14.80
Welder 15.33


I need a formula in column C that would look at the job title in Column A
and give me the minimum amount a Foreman would make. For example in columnC
for both foreman the result of the formula would be 17.50. The results for
the Asst. Foreman would be 14.50. I then would have a formula in column D
that would show how much difference in the employees current wage to the
minimum amount for the person with similar job title.


Thanks for the help.