Take a look at VLOOKUP in Excel Help - this will do what you want to do
quite easily.

Hope this helps.

Pete

wrote in message
...
I have an Excel worksheet with a column indicating approx. 11
different positions (this number will probably increase). I would
like Excel to automatically insert a salary in one column based on the
job title inserted in the column prior.

e.g.

Supervisor typed in one column with automatically insert the salary in
the next column $100,000.00
Foreman typed in will automatically insert $75,000.00 in the next
column (Salary column)
Labour - $50,000.00 will insert in next column
Labour + 10 yrs will insert $55,000.00
Labour + 20 yrs will insert $60,000.00
etcetera....

I am a basic Excel user and have been trying IF as well as IF AND and
have been getting a lot of errors.

I would also be interested in a column that has a person with a Labour
title, automatically change to Labour+ 10 yrs, once the 10 years from
the start date has been reached. This would then change the salary
automatically (per above) to an increased amount.

Thank you.