Excel 2007 : drop box

[captian hook]

The pumps is a drop box with a list of pump 1 -4. I need to be able to have the cell next to the pump box change its value as with a selection.
Thanks for your help.




Pumps





pump 1 100
pump 2 200
pump 3 300
pump 4 400

[bonny24tycoon]

Hi captian hook,

This can be done.. So tel me if im right.. So if the selection is 1 the adjacent cell should be 100??


Thanks,

Bonny Tycoon



**If I was able to help please click the small star icon at the bottom left of my post **

[bonny24tycoon]

Hi captian hook,


Try this out.. Book1.xlsx



Thanks,

Bonny Tycoon


**If I was able to help please click the small star icon at the bottom left of my post **

[royUK]

Use VLOOKUP. See the example here

[bonny24tycoon]

Hi captian hook,

Great.. Im happy that your query is been resolved.

Can you mark this thread as solved by going to thread tools and then marking it as solved.


Thanks,

Bonny Tycoon



**If I was able to help please click the small star icon at the bottom left of my post **