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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed with cell reference
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed with cell reference
Thanks. That is a slightly different format than I was using. I'll see what
happens. Les "Sandy Mann" wrote: I assumed from: A1 = 2008 (This is a hyperlink that links to worksheet('2008') that your formula was in A1. =IF(INDIRECT(A1&"!G24")=0,"",INDIRECT(A1&"!"&A2&A3 )) works for me. -- 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 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed with cell reference
Works Great!!!
Thanks, Les "Sandy Mann" wrote: I assumed from: A1 = 2008 (This is a hyperlink that links to worksheet('2008') that your formula was in A1. =IF(INDIRECT(A1&"!G24")=0,"",INDIRECT(A1&"!"&A2&A3 )) works for me. -- 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 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed with cell reference
"WLMPilot" wrote in message
... Works Great!!! Glad that it worked for you. Thanks for the feedback. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk |
Reply |
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 |