IF function with link to different lists

R

Ruslan

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.
 
S

Stefi

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
Excel - Wich Function should I use? 1
Tranfer data from Excel to word (Docx) via VBA in Excel 5
Conditional Formatting Formula 3
CAN YOU SOLVE THIS!!!!!!! 2
Can you do it ??????? 2
Sumproduct in VBA 10
Activate / deactivate a link based on the value of a cell 0

Top