View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ruslan Ruslan is offline
external usenet poster
 
Posts: 12
Default IF Function with the link to different lists

Dear friend. Please help me with the following. I want to create a formula
(perhaps must be realized via VBA) that .. depending on what I choose in A1
cell ("standard" or "gold" options) cell B1 must provide me with the
according list of options. For example, If I choose Standard in A1, cell B1
must show me the list indicated in D1:D10 or if I choose Gold in A1, cell B1
must shopw me the list in E1:E10.
Thanks you very much in advance.