I'm trying to get it to work with a cell from the same document, but a different sheet.
I can get indirect to work, such as:
=INDIRECT("C"&A1+4) [this is in cell C1 off of the same sheet, which is called "Contact_List"]
Is used to pull it onto another page.
However, I really want to be able to import this "Contact List" sheet from another document; thus, having the first line on the same page does not allow this.
But if I can somehow get the first equation (or one like it) to pull info off of a different sheet while still using a variable - this would be great (and what I need to accomplish).
All help is appreciated.
OKAY, FOR WHAT IT'S WORTH, I FIGURED IT OUT.
The appropriate syntax is...
Where A1 is the row referred to, B1 is the column, and "Other_Sheet" is the name of the sheet you are grabbing from.
If cell A1 had "2" in it, and cell B1 had "4" in it, this would call up cell 'D2' from the sheet "Other_Sheet". Without the "indirect" function, the cell would literally say "Other_Sheet.$D$2". To get the Value of that cell, you need to use the 'Indirect' function along with the 'Address' function, as shown.
You can also subract/add row or column offsets, simply by adding numbers. For example...
Thus, A1=2 and B1=4 would return "2+3" and "4-2" (or 5 and 2), which would equate to cell 'B5' on "Other_Sheet".
Be aware that you don't have to use both variables (i.e. - A1 and B2). You could simply put in a number that represents the row or column (3 would represent either row "three" or column "C", depending on which variable you wanted to be set).
This would also return cell 'B5'.
(FYI, the other variables listed, the "1" and the blank space, are (somewhat) explained in OO Help).
I hope this helps others!
OpenOffice 3.1 on Windows XP