The offset function wants an address as the first parameter. Use the indirect function to supply it:
offset(indirect(sheet3.D4);3;2)
If cell sheet3.D4 contains the value "sheet2.A15" then the function above should return the contents of cell sheet2.C18, which is three rows over and two seats down. I know it's three rows down and two columns over, but nobody wrote a song with those words.
tc
Anthony Chilco wrote:
Hi Nick,
You're right. It is simple. Somewhere I've got a spreadsheet with a similar function and it does work. I'll see if I can find it here (I'm at home). It may be at work, though.
tc
Nick Samuel wrote:
Hello,
I am trying to look up values on a sheet from a position specified in another cell on the sheet.
I work out, using a formula, where in the sheet I want to start:
e.g. sheet2.A15
This appears in a spreadsheet cell
e.g. Cell sheet3.D4 contains the value "sheet2.A15"
I then tried to use the OFFSET function to look up values in a two-dimensional array starting at sheet2.A15.
I cannot find a way of telling OFFSET that the starting address is in the cell sheet3.D4.
I assume it is simple to do but I just cannot see it.
Regards,
Nick
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
