G
Graeme
Hello,
I have been given a workbook with two worksheets. The first sheet is named
summary and the second sheet is named ...o&b. I am trying to use the
indirect formula to return a value into the summary sheet from the ...o&b
sheet. So far I have tried the following in the summary sheet.
A1 B1
'...o&&b' =indirect(A1,"!C16")
i.e I am attempting to lookup the value in ...o&b!c16 and return it to cell
B1 by reference to cell A1.
However, this doesn't seem to work. I think the ampersand is an illegal
character. I can't change the worksheet names as the workbook has been
exported from a centralised mainframe.
Any help appreciated.
Graeme.
I have been given a workbook with two worksheets. The first sheet is named
summary and the second sheet is named ...o&b. I am trying to use the
indirect formula to return a value into the summary sheet from the ...o&b
sheet. So far I have tried the following in the summary sheet.
A1 B1
'...o&&b' =indirect(A1,"!C16")
i.e I am attempting to lookup the value in ...o&b!c16 and return it to cell
B1 by reference to cell A1.
However, this doesn't seem to work. I think the ampersand is an illegal
character. I can't change the worksheet names as the workbook has been
exported from a centralised mainframe.
Any help appreciated.
Graeme.