Drop Down Form Number List

Hey there ,

I have built a simple drop down menu from 0-99 being selected from a series of cells

Numbers!$A$1:$A$100

where A:1= 0
and a:100 = 99

and linked to cell using

'Bundled Systems'!$B$2

under the format control dialogue box.

HOWEVER

when the selected number from the drop down box is added to the 'Bundled Systems'!$B$2 field there is 1 added to it

That is
select 1 and return 2
select 10 return 11
etc

can anyone please let me know why this might be happening?

Thanks

Hi,
The link cell contains the row number (index) of the selected value
NOT the value itself so A1 contains 0 and selection 0 will place 1 in B2.


If you want the value, in another cell e.g C1, you could put =indirect("A" &
'Bundled Systems'!$B$2)

HTH

"Prellyan" wrote:

>
> Hey there ,
>
> I have built a simple drop down menu from 0-99 being selected from a
> series of cells
>
> Numbers!$A$1:$A$100
>
> where A:1= 0
> and a:100 = 99
>
> and linked to cell using
>
> 'Bundled Systems'!$B$2
>
> under the format control dialogue box.
>
> HOWEVER
>
> when the selected number from the drop down box is added to the
> 'Bundled Systems'!$B$2 field there is 1 added to it
>
> That is
> select 1 and return 2
> select 10 return 11
> etc
>
> can anyone please let me know why this might be happening?
>
> Thanks
>
>
> --
> Prellyan
> ------------------------------------------------------------------------
> Prellyan's Profile: http://www.excelforum.com/member.php...o&userid=30539
> View this thread: http://www.excelforum.com/showthread...hreadid=501944
>
>