View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default Help needed with cell reference

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