Help needed with cell reference

[WLMPilot]

I am trying to piece together info from three cells in an effort to reference
another cell.

EXAMPLE
A1 = 2008 (This is a hyperlink that links to worksheet('2008')
A2 = 19
A3 = G

The active worksheet is STATS. Can a formula can be setup to reference
2008!G19 by referencing A1, A2, and A3?

The current formula is IF(2008!G24=0,"",2008!G19)

It is to complicated to explain why I need it this way, but I just do.

Thanks,
Les

 

[Sandy Mann]

Try:

=IF('2008'!G24=0,"",INDIRECT("2008!"&A2&A3))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[WLMPilot]

I need A1 in there instead of "2008!" for the year reference. I did try
INDIRECT but kept getting #REF error. Was not sure how to fix problem. I
may look at INDEX to see if I can figure something out

The reason I am going through all of this is it is way to much trouble to
change the cell references from year to year. If each year is a mirror image
of each other than I can indicate column, row, and year and piece it together
to reference what I need.

Thanks,
Les

 

[Sandy Mann]

I assumed from:

that your formula was in A1.

=IF(INDIRECT(A1&"!G24")=0,"",INDIRECT(A1&"!"&A2&A3))

works for me.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[WLMPilot]

Thanks. That is a slightly different format than I was using. I'll see what
happens.

Les

 

[WLMPilot]

Works Great!!!

Thanks,
Les

I assumed from:


that your formula was in A1.

=IF(INDIRECT(A1&"!G24")=0,"",INDIRECT(A1&"!"&A2&A3))

works for me.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

Works Great!!!

Glad that it worked for you. Thanks for the feedback.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk