0

Sorry for the confusing title, I'm pretty confused myself.

Basically, what I'm trying to do is:

='Sheet 3'!(F2 in current worksheet)

So in Cell F2, I have a value of "G69"

The end result I want to achieve is

='Sheet3'!G69

On cell F2, my formula is:

=CONCATENATE("G", E2)

Bonus point if you can do this...:

='Sheet 3'!(Value of Concatenate("G",A1)

THANK YOU FOR ANY HELP YOU CAN PROVIDE!

EDIT: =INDIRECT("'Sheet 2'!F2")is the answer I was looking for. Thanks guys!

redbean1100010
  • 29
  • 2
  • Can you please add more information ? –  May 21 '18 at 10:16
  • 1
    What type of information do you need?? – redbean1100010 May 21 '18 at 10:20
  • Could you give me an example? – redbean1100010 May 21 '18 at 10:22
  • http://www.contextures.com/xlFunctions05.html – QHarr May 21 '18 at 10:24
  • 1
    possible duplicate of [Using the value in a cell as a cell reference in a formula?](https://stackoverflow.com/questions/12150861/using-the-value-in-a-cell-as-a-cell-reference-in-a-formula) or [How to make a reference to a cell of another sheet, when the sheet name is the value of a cell?](https://stackoverflow.com/questions/258053/how-to-make-a-reference-to-a-cell-of-another-sheet-when-the-sheet-name-is-the-v) – Glitch_Doctor May 21 '18 at 10:24

0 Answers0