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