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

Dear All,
Please help me with the following. Sample: Cell A1 consists of list ("Gold",
"Standard"). If I choose "Gold", then B1 must open to the lists of options
indicated in cells D1:D10. If I choose "Standard", then B1 must open the list
of options indicated in cells E1:E10.
I guess I should use VBA. Thank you in advance.