Variable Cell References

[HisHighness]

Hey all I'd like to set a sheet up so that I can something like the following:

A(A2)

And then when I type a digit in to A2 it would change to reference that cell, so if I type "5" in to A2 It would reference A5, if I typed 20 in to A2 it'd reference A20 and so on.

Thanks for your time.

[davesexcel]

=indirect("a"&a2)

[HisHighness]

Thanks, also how can I use that in conjunction with calling from another sheet?

I've tried ='Sheet1'!INDIRECT("a"&a2)

But that doesn't work

[davesexcel]

Thanks, also how can I use that in conjunction with calling from another sheet?

I've tried ='Sheet1'!INDIRECT("a"&a2)

But that doesn't work

=INDIRECT("Sheet1!A"&A1)

[papagreybeard]

Trying to do the same with a reference to another sheet in another workbook...trying:

=INDIRECT("[GGOB Data Final.xlsx]P&L - TARGETED!"&A20&"125")

where cell A20 in the current sheet contains the column needed in the reference sheet and 125 is the row in the reference sheet.

What am I doing wrong?

Thanks for your help

[ratcat]

Trying to do the same with a reference to another sheet in another workbook...trying:

=INDIRECT("[GGOB Data Final.xlsx]P&L - TARGETED!"&A20&"125")

where cell A20 in the current sheet contains the column needed in the reference sheet and 125 is the row in the reference sheet.

What am I doing wrong?

Thanks for your help

G'day Papa,

and welcome to the forum.

From your description you need the Index formula with a Match nested.

Info on the Index formula http://www.contextures.com/xlFunctions03.html

If you have further problems, search the forum for an answer and if that doesn't help, please start a new thread and the forum will be more than happy to help you further.

Cheers