data validation

[Guest]

I have a cell in which a payment type is selected, eg "CREDIT CARD" or
"CHEQUE" and so on. What I want to from here is change the selection list in
another cell based on what is selected in the first. E.g. if "CREDIT CARD"
is selected then the list in the next cell is for card types. If "CHEQUE" is
selected then the list in the next cell is Bank Names.

Is this achievable?

Thanks in advance

 

[Guest]

Hi,

This is a simple solution without any error checking built in. i.e it will
allow you to select a card type when Cheque is selected in the first cell.

I assume you know how to use data validation from the question.

In Data > Validation choose List from the Allow dropdown box. In the Source
box you can enter a formula. Replace square bracketed text with the actual
references.

=If([Payment type cell] = "Cheque", [Card Type Range],[Cheque Range])

HTH,
Matt

 

[Bob Phillips]

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

--
HTH

Bob Phillips

Hi,

This is a simple solution without any error checking built in. i.e it will
allow you to select a card type when Cheque is selected in the first cell.

I assume you know how to use data validation from the question.

In Data > Validation choose List from the Allow dropdown box. In the Source
box you can enter a formula. Replace square bracketed text with the actual
references.

=If([Payment type cell] = "Cheque", [Card Type Range],[Cheque Range])

HTH,
Matt

I have a cell in which a payment type is selected, eg "CREDIT CARD" or
"CHEQUE" and so on. What I want to from here is change the selection list in
another cell based on what is selected in the first. E.g. if "CREDIT CARD"
is selected then the list in the next cell is for card types. If "CHEQUE" is
selected then the list in the next cell is Bank Names.

Is this achievable?

Thanks in advance