ok, I have a situation where I have 2 cells on sheet2 that define the starting and stopping points of a range that I need to reference. I need to reference them from another sheet (sheet1). I cannot however get it to work.

for example,

on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)

cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a cell on Sheet2, but I need to get the cell in sheet2 that is referenced by cell a1 in sheet2 back into sheet1

it doesn't like the first 'Sheet2'!, it keeps giving me an error. I can take it off so that I am left with =indirect('Sheet2'!a1) but then it will be referencing a cell on sheet1. I am just not sure what the correct syntax is.

Actually this is just part of a much larger equation...but this is the part I can't seem to get to work.

thanks in advance for any help

## Bookmarks