IF function with link to different lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Create a validation list in B1 with the following formula in the Source field:
=IF(A1="Gold",D1:D10,E1:E10)

Regards,
Stefi


„Ruslan†ezt írta:
 

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

IF Function with the link to different lists 2
Tranfer data from Excel to word (Docx) via VBA in Excel 5
CAN YOU SOLVE THIS!!!!!!! 2
Can you do it ??????? 2
Cells with varying number of lines 1
Sumproduct in VBA 11
Time Calculations Help 4
How to dynamically change the list in drop down list based on thevalue of another cell? 1

Back
Top