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.