Variable in if statement
Thanks - will do - I was about to post again saying 'Ops, no square brackets
in this case.
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
|
|
|