Excel formula question

[Closed]
Report
-
Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
-
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 reply

Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
488
Hi,

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

Best regards