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.
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
>
>
>
>