Dave Peterson
12/19/2006 12:46:00 AM
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