| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop down cell link to worksheet not working
If A1:A100 is the range of values and B1 is the linked cell:
=if(b1=0,"",index(a1:a100,b1)) Matt wrote: I have a Dialog box with a combo list (Form Control), I have selected an input range with 5 cells selected from a spreedsheet. The Problem I am facing at the moment is when I use the "cell Link" command back to a cell in my worksheet it does not show the true content ... Eg if I select my second value (1250) in the combo list, it displays '2' back in my worksheet cell instead of the true value.. How would I change that sequence to show my true values? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down cell link to worksheet not working | Excel Programming | |||
| How to link a drop down value to a cell in a different worksheet? | Excel Worksheet Functions | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| Link Second drop-down list to a Worksheet | Excel Programming | |||
| Link Second drop-down list to a Worksheet | Excel Programming | |||
Linear Mode
