Trying to use data from another worksheet

[Captain Ron]

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

 

[Spiky]

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.

 

[Captain Ron]

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]

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

This should work, copied into column D on WS#1:
=VLOOKUP(B2,'WS#2'!$B$1:$E$5,C2+1)

You'll have to adjust the range to fit your source database. And make
sure your grades are all typed perfectly on both sheets.

 

[Captain Ron]

Thanks Spiky. Greatly appreciate your time!

This should work, copied into column D on WS#1:
=VLOOKUP(B2,'WS#2'!$B$1:$E$5,C2+1)

You'll have to adjust the range to fit your source database. And make
sure your grades are all typed perfectly on both sheets.