Help referencing another cell using a formula

[JusticePope]

Basically I am working on a spreadsheet that requires me to reference another cell without using the fill handle so that if I change some of the manually entered data, everything changes accordingly.

Right now it looks something like
B2=B31 and I need D2=B32 without having to manually enter B32. B3 however is B3=B34, and in D3 I need it to be D3=B35.

I've seen talk of using INDIRECT and ROW or COLUMN, but I cannot seem to get it to work. I would like the entire D column to be whatever cell is under the cell that the B column references.

[Pepe Le Mokko]

Why post a picture when you need a sheet?

[JusticePope]

I suppose I could upload the sheet if it's entirely necessary, but all the information is there regardless. My problem seems simple, almost trivial, but I can't for the life of me get it right.

[Russell Dawson]

Post a workbook please as Pepe suggests.

In the meantime - are you sure about your request?

Right now it looks something like
B2=B31 and I need D2=B32 without having to manually enter B32. B3 however is B3=B34, and in D3 I need it to be D3=B35.

[JusticePope]

Yeah, I'm sure. Each year, every employee's salary needs to move up a step (unless they're at step 10, then they stay there). I can formulate the IF statement for that pretty easily, but getting an entirely formulated worksheet is where I'm having problems because it's not a simple fill handle drag and drop dealy.

[Russell Dawson]

What's confusing is that the s/s shows them to be in year 1. I suspect that is not the case and the only way of detecting how far up the scale they are is to compare the current salary with the salary schedule. Do you really want to replace the % entries in column D?

It might be worth thinking about revamping the s/s with a column with cells to indicate which step they are on and in the current salary column use VLOOKUP to get that figure. Then you could introduce another column for the next year to add 1 to the previous step and again find the new salary with VLOOKUP.

[JusticePope]

Sorry, apparently I'm some sort of visually impaired and can't even look at my own work right. Whenever I mentioned having information in D, I meant E. Sorry for the confusion. I'll try making a separate column and using VLOOKUP and see where that gets me.

[Russell Dawson]

You'll need also to consider which Grade they are - Batchelor, Master or Doctor. Confusion reigns when you have a salary of 44000 but no indication of Grade. Just a thought.

[JusticePope]

Yep, got all that included. VLOOKUP works like a charm. Thanks so much. Now I can finally make some progress on this silly thing.

[Russell Dawson]

This may help.