Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup or reference function needed | Excel Worksheet Functions | |||
External reference to spreadsheet names (tabs) help needed. | Excel Discussion (Misc queries) | |||
Look Up and Cell Reference - Formula Help Needed | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |