Previous Topic Next Topic

Excel formula question

Closed
jimmy - Apr 5, 2011 at 01:32 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Apr 5, 2011 at 03:27 PM
Hello,

Im not good at terminology. Sorry in advance.

I have a spreadsheet that has several formulas. for this instance, M2 =Q1-(O2) where the values in Q and O are a number. For this it would be, M2 =1-(-15). It shows the value as 16.

My R column has names. The problem I am having is I want N2 to =R16 (the # value represented in M2). I have tried N2 =R(Q1-(O2)) and =R(M2). I want to set this on multiple rows so I do not have to type in =R# over 250 rows.

Does anyone have any advice?


1 response

Answer 1 / 1
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Apr 5, 2011 at 03:27 PM
Hi,

Try with this formula in N2 :
=INDIRECT(CONCATENATE("R",M2))

Best regards
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
Keyboard troubles
jimbobjoe -
car -

38 responses