Sorry Nick - I cannot do it - keep getting #REF! or zero

=INDIRECT("Present!R" & RC[-2] & "C5")...............#REF!
=INDIRECT(Present!R & "RC[-2]" & C5).................#REF!
=INDIRECT(Present!R + RC[-2] + C5)..........................0

The number in RC[-2] of the active sheet is the row number in colomn 5 of
sheet 'Present' which I want to get.

Francis


"Niek Otten" wrote in message
...
Hi Francis,

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Francis Hookham" wrote in message
...
| 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
|
|