# Row Function in cell reference

#### Willmonbo

##### Board Regular
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?

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
This would work:

=INDIRECT("D"&ROW())

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

both of these work
Excel Workbook
DE
52525
6
7
8555555
Sheet1
Excel 2010
Cell Formulas
RangeFormula
E8=INDIRECT("D"&ROW())

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 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())

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.

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?

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.

Another way

=INDIRECT("RC4",0)

Replies
10
Views
221
Replies
10
Views
179
Replies
4
Views
112
Replies
1
Views
230
Replies
0
Views
197

1,218,575
Messages
6,143,311
Members
450,477
Latest member
teresab543

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back