Excel question - need to increment a cell's location within formula

[fbrdphreak]

OK here's the deal: I have a formula which references a cell. I want to use a value in another cell which I can change to increment which cell I'm referencing.

Here's an example:

Value in cell H1: 0
Cell referenced: D3+H1 = D3+0 = D3

Value in cell H1: 1
Cell referenced: D3+H1 = D3+1 = D4

Value in cell H1: 2
Cell referenced: D3+H1 = D3+2 = D5

All of the values I need to reference are in the same column, so I need to be able to increment down the column. I can't figure out how to increment a column location by an integer, how do you do this??

Thanks all!

 

[mayest]

If I understand what you are trying to do, this will do the trick:

=INDIRECT(ADDRESS(H1+3,4))

Indirect converts a string address to a real address. The Address function returns a string-based address based on row and column numbers.

If your first cell is in some row other than 3, then change the 3 to that value. Similarly, if you change from column D, you need to change the 4 to another value (A = 1, B = 2, etc).

Tim

 

[fbrdphreak]

EDIT Nevermind, I got it! Thanks so much

 

[mayest]

:thumbsup: Glad it worked for you.