View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default Help needed with cell reference

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