Row Function in cell reference

[Willmonbo]

I am trying to do something that I think should be fairly easy and perhaps I have even done in the past but can't figure out now what i'm missing.

I just want to reference the cell in column D of the same row that I am working in, how do I do that?

 

[Airfix9]

This would work:

=INDIRECT("D"&ROW())

 

[Willmonbo]

I am trying this formula now in a named range and am getting a #value error any thoughts on why?

 

[scottylad2]

both of these work

Excel Workbook
	D	E
5	25	25
6
7
8	555	555
Sheet1

Excel 2010

Cell Formulas
Range	Formula
E5	=INDIRECT(ADDRESS(ROW(),4))
E8	=INDIRECT("D"&ROW())

 

[Willmonbo]

are you saying that both these formulas should work in a named rang as well, because I have tried them both and am getting the #value error on both, any thought as to why?

 

[T. Valko]

I am trying to do something that I think should be fairly easy and perhaps I have even done in the past but can't figure out now what i'm missing.

I just want to reference the cell in column D of the same row that I am working in, how do I do that?

Try this...

=INDEX(D:D,ROW())

 

[T. Valko]

are you saying that both these formulas should work in a named rang as well, because I have tried them both and am getting the #value error on both, any thought as to why?

It depends on how you're defining the range.

Show us the formula you're using.

 

[scottylad2]

are you saying that both these formulas should work in a named rang as well, because I have tried them both and am getting the #value error on both, any thought as to why?

I'm a tad puzzled

can you explain what you mean by having them in a named range?

 

[Willmonbo]

i was just looking for a way to ease data input, since the data that I needed to input was always going to be a calculation based on the values in column D of the row that I am currently in, I was going to create a "Defined Name" with a formula (which is what I needed help with) to look back to column D.

the index method does work, however the other two do not, I hope I have explained it better this time around, feel free to ask for more clarification if needed.

thanks everybody for your respective input.

 

[jasonb75]

Another way

=INDIRECT("RC4",0)