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" wrote:

Try:

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

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"WLMPilot" wrote in message
...
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