Drop down lists - thanks (and one more query)

  • Thread starter Thread starter Alex McKenzie
  • Start date Start date
A

Alex McKenzie

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Value of drop-down list 1
drop downs and hyperlinks 2
Drop-down list and error message 1
Dependent drop down dynamic range formula, off sheet. 7
sizing in Drop Down lists 6
use v lookup from a drop down list 5
Drop Down List Conditional Formating 2
Can I increase the view of a drop down list beyond 8 in Excel? 2

Back
Top