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.

IF Function with the link to different lists
 

Look he

http://www.contextures.com/xlDataVal02.html

"Ruslan" wrote:

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.

IF Function with the link to different lists
 

What you're looking for is "dependant lists".

Check out this web page of Debra Dalgleish on this subject:

http://www.contextures.com/xlDataVal02.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ruslan" wrote in message
...
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.