Thanks Spiky. Greatly appreciate your time!
"Spiky" wrote:

On Apr 24, 9:42 pm, Captain Ron
wrote:
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.