Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference to cell with text is returning #VALUE
I have a cell that references a different cell that that consists of H9:J9
that is formated for and contains text. The referenceing cell shows #VALUE instead of the actual text that is in the cell? Any ideas as to why this is happening? Any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference to cell with text is returning #VALUE
What does your formula look like?
A simple link formula can only reference a single cell. Like this: =H9 You can't reference a range of cells like this: =H9:J9 That is why you're getting the error. -- Biff Microsoft Excel MVP "Jorist" wrote in message ... I have a cell that references a different cell that that consists of H9:J9 that is formated for and contains text. The referenceing cell shows #VALUE instead of the actual text that is in the cell? Any ideas as to why this is happening? Any help would be appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference to cell with text is returning #VALUE
I have a series of merged cells H9:J9 that contain text. I am trying to
reflect the contects of this merged cell in another cell on a different tab. I am using the following reference: ='Current Market Conditions'!H9:J9 This is retruning the #VALUE error. I am using the same syntax on another series of merged cells ='Current Market Conditions'!B38:K38 which is returning the text found in this merged cell series correctly. Any ideas as to why the first one is giving me a #VALUE error and the second one is not? Thanks. J "T. Valko" wrote: What does your formula look like? A simple link formula can only reference a single cell. Like this: =H9 You can't reference a range of cells like this: =H9:J9 That is why you're getting the error. -- Biff Microsoft Excel MVP "Jorist" wrote in message ... I have a cell that references a different cell that that consists of H9:J9 that is formated for and contains text. The referenceing cell shows #VALUE instead of the actual text that is in the cell? Any ideas as to why this is happening? Any help would be appreciated. . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference to cell with text is returning #VALUE
When referencing a merged cell, reference the top left cell.
A1:C5 is a merged cell. =A1 ='Current Market Conditions'!H9:J9 Reference cell H9: ='Current Market Conditions'!H9 ='Current Market Conditions'!B38:K38 which is returning the text found in this merged cell series correctly. That's just "dumb luck". It depends on what cell the formula is in. Try entering that formula in cell AA100. Reference cell B38 ='Current Market Conditions'!B38 -- Biff Microsoft Excel MVP "Jorist" wrote in message ... I have a series of merged cells H9:J9 that contain text. I am trying to reflect the contects of this merged cell in another cell on a different tab. I am using the following reference: ='Current Market Conditions'!H9:J9 This is retruning the #VALUE error. I am using the same syntax on another series of merged cells ='Current Market Conditions'!B38:K38 which is returning the text found in this merged cell series correctly. Any ideas as to why the first one is giving me a #VALUE error and the second one is not? Thanks. J "T. Valko" wrote: What does your formula look like? A simple link formula can only reference a single cell. Like this: =H9 You can't reference a range of cells like this: =H9:J9 That is why you're getting the error. -- Biff Microsoft Excel MVP "Jorist" wrote in message ... I have a cell that references a different cell that that consists of H9:J9 that is formated for and contains text. The referenceing cell shows #VALUE instead of the actual text that is in the cell? Any ideas as to why this is happening? Any help would be appreciated. . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference to cell with text is returning #VALUE
Thanks. I thought that I had tried that but I guess not.
Just as as side not to anyone reading this posting: The formula that I used was obtained by typing = and then navigating to the cell on the page that I wanted to reference. This is where the formula ='Current Market Conditions'!H9:J9 was created automatically by Excel. This formula appears to be incorrect. ('Current Market Conditions' is the name of the page where the reference cell is located.) Making the correction suggested by T. Valko, the formula worked perfectly. Thanks again. Jorist "T. Valko" wrote: When referencing a merged cell, reference the top left cell. A1:C5 is a merged cell. =A1 ='Current Market Conditions'!H9:J9 Reference cell H9: ='Current Market Conditions'!H9 ='Current Market Conditions'!B38:K38 which is returning the text found in this merged cell series correctly. That's just "dumb luck". It depends on what cell the formula is in. Try entering that formula in cell AA100. Reference cell B38 ='Current Market Conditions'!B38 -- Biff Microsoft Excel MVP "Jorist" wrote in message ... I have a series of merged cells H9:J9 that contain text. I am trying to reflect the contects of this merged cell in another cell on a different tab. I am using the following reference: ='Current Market Conditions'!H9:J9 This is retruning the #VALUE error. I am using the same syntax on another series of merged cells ='Current Market Conditions'!B38:K38 which is returning the text found in this merged cell series correctly. Any ideas as to why the first one is giving me a #VALUE error and the second one is not? Thanks. J "T. Valko" wrote: What does your formula look like? A simple link formula can only reference a single cell. Like this: =H9 You can't reference a range of cells like this: =H9:J9 That is why you're getting the error. -- Biff Microsoft Excel MVP "Jorist" wrote in message ... I have a cell that references a different cell that that consists of H9:J9 that is formated for and contains text. The referenceing cell shows #VALUE instead of the actual text that is in the cell? Any ideas as to why this is happening? Any help would be appreciated. . . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference to cell with text is returning #VALUE
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Jorist" wrote in message ... Thanks. I thought that I had tried that but I guess not. Just as as side not to anyone reading this posting: The formula that I used was obtained by typing = and then navigating to the cell on the page that I wanted to reference. This is where the formula ='Current Market Conditions'!H9:J9 was created automatically by Excel. This formula appears to be incorrect. ('Current Market Conditions' is the name of the page where the reference cell is located.) Making the correction suggested by T. Valko, the formula worked perfectly. Thanks again. Jorist "T. Valko" wrote: When referencing a merged cell, reference the top left cell. A1:C5 is a merged cell. =A1 ='Current Market Conditions'!H9:J9 Reference cell H9: ='Current Market Conditions'!H9 ='Current Market Conditions'!B38:K38 which is returning the text found in this merged cell series correctly. That's just "dumb luck". It depends on what cell the formula is in. Try entering that formula in cell AA100. Reference cell B38 ='Current Market Conditions'!B38 -- Biff Microsoft Excel MVP "Jorist" wrote in message ... I have a series of merged cells H9:J9 that contain text. I am trying to reflect the contects of this merged cell in another cell on a different tab. I am using the following reference: ='Current Market Conditions'!H9:J9 This is retruning the #VALUE error. I am using the same syntax on another series of merged cells ='Current Market Conditions'!B38:K38 which is returning the text found in this merged cell series correctly. Any ideas as to why the first one is giving me a #VALUE error and the second one is not? Thanks. J "T. Valko" wrote: What does your formula look like? A simple link formula can only reference a single cell. Like this: =H9 You can't reference a range of cells like this: =H9:J9 That is why you're getting the error. -- Biff Microsoft Excel MVP "Jorist" wrote in message ... I have a cell that references a different cell that that consists of H9:J9 that is formated for and contains text. The referenceing cell shows #VALUE instead of the actual text that is in the cell? Any ideas as to why this is happening? Any help would be appreciated. . . |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference to cell with text is returning #VALUE
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell reference returning incorrect value | Excel Discussion (Misc queries) | |||
Cell reference returning cell name instead of value | Excel Discussion (Misc queries) | |||
Returning the cell reference when you find a value in an array | Excel Worksheet Functions | |||
Returning a cell reference with a formula? | Excel Worksheet Functions | |||
Returning with cell on right/left of a reference | Excel Worksheet Functions |