This should be easy
Have a look at the indirect function in help. If you want to return the
value of cell A3 you could use:
=Indirect("A" &(1+2))
Hope this helps
Rowan
Kypreo wrote:
here is a simple formula....
=A1+2...... this assumes the cell ur looking at is A3
i want the lookup to happen from another worksheet.
eg
=sheet2!A1+2 but this doesn't work.. anyone got a work around ?
i have a worksheet full with similar functions.. a calendar type thing to
compare annual leave with rosters days on.
|