S
Scooter
Is there a way to use the text in one cell (A3, for example) in a formula in
C3 to identify the sheet (in the same workbook) to look on for data?
I am looking for the value of cell C35 on the sheet named in A3.
Basically, this is what I think C3 needs to look like:
=(_textfromA3_!C35)
I cannot figure out how to tell it to do this with a formula that I can
paste in lots of cells.
C3 to identify the sheet (in the same workbook) to look on for data?
I am looking for the value of cell C35 on the sheet named in A3.
Basically, this is what I think C3 needs to look like:
=(_textfromA3_!C35)
I cannot figure out how to tell it to do this with a formula that I can
paste in lots of cells.