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
--
paulu

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
--
paulu

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

--
HTH

Bob Phillips

"Matt Lunn" wrote in message
...
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
--
paulu