This should be easy
i get #Value! error..... meaning it cannot find a value.
i should mention that the data is all text....not numeric....although, i
dont see why it would make a difference.
basically what i want, is to have a sort of Anchor cell, then look down 2
cells down from that original cell
simply changing the lookup point manually wont do.. needs to be done within
a formula
"Biff" wrote:
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.
|