Row Function in cell reference

Willmonbo

Board Regular
Joined
May 16, 2010
Messages
141
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?
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Willmonbo

Board Regular
Joined
May 16, 2010
Messages
141
I am trying this formula now in a named range and am getting a #value error any thoughts on why?
 

scottylad2

Well-known Member
Joined
Feb 2, 2009
Messages
1,919
both of these work
Excel Workbook
DE
52525
6
7
8555555
Sheet1
Excel 2010
Cell Formulas
RangeFormula
E5=INDIRECT(ADDRESS(ROW(),4))
E8=INDIRECT("D"&ROW())
 

Willmonbo

Board Regular
Joined
May 16, 2010
Messages
141

ADVERTISEMENT

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

Well-known Member
Joined
May 9, 2009
Messages
16,623
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

Well-known Member
Joined
May 9, 2009
Messages
16,623

ADVERTISEMENT

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

Well-known Member
Joined
Feb 2, 2009
Messages
1,919
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

Board Regular
Joined
May 16, 2010
Messages
141
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,079
Messages
5,599,636
Members
414,326
Latest member
kfg1287

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?

Disable AdBlock

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
Top