Drop down lists - thanks (and one more query)  
Author Message
jaymcgill





PostPosted: Sat Oct 08 01:40:12 CDT 2005 Top

worksheet functions >> Drop down lists - thanks (and one more query)

Hi all

Thanks for the info on the drop down lists - has worked perfectly

The other thing I want to do is assign a value to the items in the list
For example

If the item selected is "Gold" then I need to assign a value (in a separate
cell)
of 100 - if the item is "British Pound" the value assigned need to be 625

I was going to use Ïf" statements for this but I have way too many items in
the list.

Any suggestions??


Many thanks

Excel439  
 
 
Roger





PostPosted: Sat Oct 08 01:40:12 CDT 2005 Top

worksheet functions >> Drop down lists - thanks (and one more query) see reply posted in .misc

Regards

Roger Govier





>Hi all
>
>Thanks for the info on the drop down lists - has worked perfectly
>
>The other thing I want to do is assign a value to the items in the list
>For example
>
>If the item selected is "Gold" then I need to assign a value (in a separate
>cell)
>of 100 - if the item is "British Pound" the value assigned need to be 625
>
>I was going to use Ïf" statements for this but I have way too many items in
>the list.
>
>Any suggestions??
>
>
>Many thanks
>
>
>
>