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.

IF function with link to different lists
 

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:

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.

IF function with link to different lists
 

Visit Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html

Ruslan wrote:

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.

--

Dave Peterson