RC[-1] contains a formula which, in this row, produces the numeral 31



The next column contains this made up formula which produces what I want



=IF(RC[-1]<"",Present!R[27]C5&" "&Present!R[27]C4,"")



I should like to replace 'R[27]' with something like this but cannot make it
work



R[RC[-1]-4]



How can I use what is in RC[-1] to bring the text from the Present page?



Thanks you



Francis Hookham