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

see reply posted in .misc

Regards

Roger Govier



Alex McKenzie wrote:

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