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

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