Thanks for responding Spiky. Let me try to explain further.

Worksheet 1
A B C
D
1 Name Grade Step
Wage
2 Blow, Joe Firefighter 3
????
3 Schmo, Joe Captain 1
????
4 Whoa, Joe Major 2
????

Worksheet that wage info will come from
A B C
D E
1 Grade Step1 Step2 Step3
Step4
2 Firefighter 10.00 11.00 12.00
13.00
3 Sergeant 14.00 15.00 16.00
17.00
4 Captain 18.00 19.00 20.00
5 Major 21.00 22.00 23.00

So will VLOOKUP work to get cell D1 in worksheet 2 to cell D2 in WS#1
cell B4 in WS #2
to cell D3 in WS#1
cell C5 in WS #2
to cell D4 in WS#1
Thanks for your help

"Spiky" wrote:

On Apr 24, 1:45 pm, Captain Ron <Captain
wrote:
I'm trying to have excel automatically input data from a worksheet into
specific cells on another worksheet. To better explain:
I have a pay plan that consists of Grades (rows) and Steps (columns)
There are 9 different pay grades (ranks) with either 3, 4, or 5 steps in them.
I have another worksheet that lists our firefighters alphabetically and
contains their pay grade and step in a column.
I want excel to transfer the hourly wage from the pay plan to the
alphabetical roster worksheet based on the pay grade and step listed in
alphabetical worksheet.

Any help????
Thanks

If the steps are numbered easily, like 1 2 3 4, and the columns in the
roster go in the same order, then you can easily use a VLOOKUP to do
this.