Junk

Ask something
Question Locked

Wrong values from drop down list

0 helpful
4 replies

by per

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

The drop down list has the values 1.6, 2.7 and 4. The cell link points to cell C2.

When getting the values from C2 i results in 1, 2 and 3.

Suppose it is showing the row number of the drop down box instead of the actual input value.

WHY?

Am I blind?

Thanks, dude.

4 replies

by too_old

I do not think I understand the problem. I was able to create a drop down list in B1 using values like yours created in A1:A3 that were then hidden. When I click on the drop down list I can select the value for B1 which is the actual value from the list not some other number.

by per

If you can choose a number or value in you list -any specified... I can?t.

I have three numbers: 1.6, 2.7 and 4.

1.6 becomes 2.
2.7 becomes 3.
4 becomes 4.

PROBLEM ONE
If I change the number/format style in 'Format', nothing changes -it still shows the numbers inexact.

PROBLEM TWO
The choosen value does not shows in the visible cell [which shall be calculated].

Thanks, friend.

/P

by bizzo

Hi,

I didn't realise that comboboxes worked like this. If your cell link is to C2, then this will only show the index of whatever is in the list, so selecting the first element returns 1, the second returns 2 etc, independent of the value.

what you need to do is to put the cell link elsewhere and use the INDEX function.

So, if your combo box has the following:
Input Range: J7:J9
Cell Link: K7
and the values of J7:J9 are 1.6, 2.7, 4
have the formula for C2 =INDEX(J7:J9,K7)

This should give the result I think you're after.

This discussion is closed to new replies.