combo box -> value ?

[555466]

Hello

how to get a value by using combo box ?

Example:

ID Number
A 10
B 40
C 100
D 200

i want the combo box to show both values (ID and Number) and after
selection,
set the Number -value to certain cell ?

How to ddo it ?

 

[Frank Kabel]

Hi
one way using data validation. See the following site for an example
sheet:
http://www.contextures.com/excelfiles.html#DataVal
http://www.contextures.com/DataValNameID.xls

 

[555466]

Frank,

thanks for very prompt reply. This solved my problem.

 

[555466]

Might be a stupid questions, but anyway, how can I add more rows (more
products), which would show also in combo box ?

 

[Frank Kabel]

Hi
just make the source list larger or use a defined name which adapts
automatically if you add more products
see
http://www.contextures.com/xlNames01.html#Dynamic