Thread
:
Help needed with cell reference
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann