Try:

=MIN(IF($A$1:$A$6=A1,$B$1:$B$6))

entered as an array formula with Ctrl + Shift + Enter

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Craig" wrote in message
...
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.