Previous Topic Next Topic

Excel formula question

Closed
jimmy - Apr 5, 2011 at 01:32 PM
aquarelle Posts 7119 Registration date Saturday April 7, 2007 Status Moderator Last seen October 18, 2022 - 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 reply

Answer 1 / 1
aquarelle Posts 7119 Registration date Saturday April 7, 2007 Status Moderator Last seen October 18, 2022 491
Apr 5, 2011 at 03:27 PM
Hi,

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

Best regards
0