Hi!

=sheet2!A1+2 but this doesn't work.. anyone got a work around ?

What does: "but this doesn't work" mean?

Do you get an error? An incorrect result?


Biff

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