This should be easy
Kypreo
Kypreo
What doesn't work?
=sheet2!A1+2 is a valid formula.
Do you have a sheet2?
Does sheet2 A1 have a value to add to?
Where is the formula =sheet2!A1+2 located?
Gord Dibben Excel MVP
On Mon, 21 Nov 2005 19:24:02 -0800, 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.
|