Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Drop-Down List
Hi,
I have a worksheet that I am using to summarize information from another tab in the same workbook (file). I need to display the contents from a drop-down list (i.e. what ever value has been selected from the list) from the main tab in the summary tab. However, when I use the standard =(maintab)'cell reference formula, the cell gives me a #VALUE error mssage. How can I solve this? Appreciate any help. Rubble |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Drop-Down List
Is the drop-down list using Data Validation? Or is a Combo box?
"Rubble" wrote: Hi, I have a worksheet that I am using to summarize information from another tab in the same workbook (file). I need to display the contents from a drop-down list (i.e. what ever value has been selected from the list) from the main tab in the summary tab. However, when I use the standard =(maintab)'cell reference formula, the cell gives me a #VALUE error mssage. How can I solve this? Appreciate any help. Rubble |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Drop-Down List
Or is it your formula:
=maintab!A1 "Rubble" wrote: Hi, I have a worksheet that I am using to summarize information from another tab in the same workbook (file). I need to display the contents from a drop-down list (i.e. what ever value has been selected from the list) from the main tab in the summary tab. However, when I use the standard =(maintab)'cell reference formula, the cell gives me a #VALUE error mssage. How can I solve this? Appreciate any help. Rubble |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Drop-Down List
Sorry, forgot to say I am using Excel 2003.
-- Rubble "Rubble" wrote: Hi, I have a worksheet that I am using to summarize information from another tab in the same workbook (file). I need to display the contents from a drop-down list (i.e. what ever value has been selected from the list) from the main tab in the summary tab. However, when I use the standard =(maintab)'cell reference formula, the cell gives me a #VALUE error mssage. How can I solve this? Appreciate any help. Rubble |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Drop-Down List
I am using Data Validation. The list source is on the same (main) worksheet.
The validation criteria is Allow: List, with In-cell dropdown. Thanks. -- Rubble "Toppers" wrote: Is the drop-down list using Data Validation? Or is a Combo box? "Rubble" wrote: Hi, I have a worksheet that I am using to summarize information from another tab in the same workbook (file). I need to display the contents from a drop-down list (i.e. what ever value has been selected from the list) from the main tab in the summary tab. However, when I use the standard =(maintab)'cell reference formula, the cell gives me a #VALUE error mssage. How can I solve this? Appreciate any help. Rubble |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Drop-Down List
Not sure what you mean. I am ponting to the cell that has the dropdown list
(in my case J59). It's what's selected in that cell that I want to appear in the summary tab. Thanks. -- Rubble "Toppers" wrote: Or is it your formula: =maintab!A1 "Rubble" wrote: Hi, I have a worksheet that I am using to summarize information from another tab in the same workbook (file). I need to display the contents from a drop-down list (i.e. what ever value has been selected from the list) from the main tab in the summary tab. However, when I use the standard =(maintab)'cell reference formula, the cell gives me a #VALUE error mssage. How can I solve this? Appreciate any help. Rubble |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Drop-Down List
=Sheet1!J59
will work (change 'sheet1' to your sheet with the DV) and I can't see why you would get a #VALUE error from a simple assignment. (I am Excel 2003) Are you simply retrieving the value or is part of a formula e.g. =Sheet1!J9*D1 "Rubble" wrote: Sorry, forgot to say I am using Excel 2003. -- Rubble "Rubble" wrote: Hi, I have a worksheet that I am using to summarize information from another tab in the same workbook (file). I need to display the contents from a drop-down list (i.e. what ever value has been selected from the list) from the main tab in the summary tab. However, when I use the standard =(maintab)'cell reference formula, the cell gives me a #VALUE error mssage. How can I solve this? Appreciate any help. Rubble |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Drop-Down List
Thanks - your answer got me to go back and look at the formula one more time.
I originally created the link by typing "=", going to the other tab and clicking on the apprpriate cell, then hitting the enter key. What I was not picking up (someone else created the spreadsheet in the first place) was that the dropdown list actually is across merged cells. When I looked more closely at the reference formula, I realized the formula included the merged cell range. Once I eliminated the range, leaving only the first cell in the series, all was fine. The perils of working first thing in the morning with no caffeine. Now that I have have had coffee, all is fine. Thanks for your quick assistance. -- Rubble "Toppers" wrote: =Sheet1!J59 will work (change 'sheet1' to your sheet with the DV) and I can't see why you would get a #VALUE error from a simple assignment. (I am Excel 2003) Are you simply retrieving the value or is part of a formula e.g. =Sheet1!J9*D1 "Rubble" wrote: Sorry, forgot to say I am using Excel 2003. -- Rubble "Rubble" wrote: Hi, I have a worksheet that I am using to summarize information from another tab in the same workbook (file). I need to display the contents from a drop-down list (i.e. what ever value has been selected from the list) from the main tab in the summary tab. However, when I use the standard =(maintab)'cell reference formula, the cell gives me a #VALUE error mssage. How can I solve this? Appreciate any help. Rubble |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Drop-Down List
To finish: avoid using merged cells as they cause many problems - as you have
discovered! "Rubble" wrote: Thanks - your answer got me to go back and look at the formula one more time. I originally created the link by typing "=", going to the other tab and clicking on the apprpriate cell, then hitting the enter key. What I was not picking up (someone else created the spreadsheet in the first place) was that the dropdown list actually is across merged cells. When I looked more closely at the reference formula, I realized the formula included the merged cell range. Once I eliminated the range, leaving only the first cell in the series, all was fine. The perils of working first thing in the morning with no caffeine. Now that I have have had coffee, all is fine. Thanks for your quick assistance. -- Rubble "Toppers" wrote: =Sheet1!J59 will work (change 'sheet1' to your sheet with the DV) and I can't see why you would get a #VALUE error from a simple assignment. (I am Excel 2003) Are you simply retrieving the value or is part of a formula e.g. =Sheet1!J9*D1 "Rubble" wrote: Sorry, forgot to say I am using Excel 2003. -- Rubble "Rubble" wrote: Hi, I have a worksheet that I am using to summarize information from another tab in the same workbook (file). I need to display the contents from a drop-down list (i.e. what ever value has been selected from the list) from the main tab in the summary tab. However, when I use the standard =(maintab)'cell reference formula, the cell gives me a #VALUE error mssage. How can I solve this? Appreciate any help. Rubble |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If referencing drop-down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Disabling Drag And Drop Referencing | New Users to Excel | |||
Drop List Referencing | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |