dropdown with name and value

[Pelle]

hi

im looking for a way to make a dropdown list with the list on the left(80,100,150) and when i click say 80 the value 0,09 if i click 100 the value 0,14 will be added to a cell that i can use for the calculations forward

80 0,09
100 0,14
150 0,34
200 0,64
250 1,04
300 1,55

hope someone know what im trying on her!!

 

[Sinu]

Is this what you're looking for?

 

[Pelle]

yes this is what i need. but can cant figure out how you made it.

 

[Sinu]

The dropdown has a linked cell B1. since all the values coming from the drop down is string, i have C1 which does B1*1 which converts that string into number. then i do a vlookup of that string in the lists

 

[Sathish KV]

Hi,

You can just use a dropdown list and a vlookup formula