CODEWITHSUNDEEP
excelexcel-2010
Edward Joseph Hammersmith
Edward Joseph Hammersmith

Reputation: 3

MICROSOFT EXCEL 2010: Reference One Cell Value To Get Row #

Is there any possible way to get a certain row value by using the value of different cell?

For example: My current cell information is 

=Estimates!R6C12

It is referencing a different sheet with the value of Row 6 and Column 12.

Now for each month I copy the previous months data, however I would like to be able to change just that single cell based on cell [Like Row# = ? ]

Is there any way to do this? Something like this?

=Estimates!R(R[-21]C])C10

Upvotes: 0

Views: 89

Answers (2)

Technichor
Technichor

Reputation: 66

INDIRECT is a volatile function and should never be used. INDEX works just as well and is not volatile.

=INDEX(Estimates!$A$1:$Z$25,6,12)

Upvotes: 1

Neil Frick
Neil Frick

Reputation: 51

Your question isn't totally clear, but it sounds like you might want to use the INDIRECT() formula.

=INDIRECT("Estimates!R"&ROW([reference])&"C10",false)

Then the row would be the row of a reference cell, and the column would be 10.

Upvotes: 0

Related Questions