I do have three Insert > Name > Define > lists created on one
worksheet.

How to have either one of the 1st two list activated on a cell when the
neighboring cell a value is choosen from the 3rd list list?

So:

List A
1
2
3

List B
A
B
C

List C
Yes
No

If Yes > List A
If No > List B

Bart
Excel 2003

Is this used with Data|Validation?

If yes, Debra Dalgleish shows how to create dependent lists:
http://contextures.com/xlDataVal02.html

AA Arens wrote:
>
> I do have three Insert > Name > Define > lists created on one
> worksheet.
>
> How to have either one of the 1st two list activated on a cell when the
> neighboring cell a value is choosen from the 3rd list list?
>
> So:
>
> List A
> 1
> 2
> 3
>
> List B
> A
> B
> C
>
> List C
> Yes
> No
>
> If Yes > List A
> If No > List B
>
> Bart
> Excel 2003

--

Dave Peterson

I assume that you mean Data Validation.

Just use DV with an allow type of List and a formula of

=IF(C1="Yes",ListA,ListB)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"AA Arens" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I do have three Insert > Name > Define > lists created on one
> worksheet.
>
> How to have either one of the 1st two list activated on a cell when the
> neighboring cell a value is choosen from the 3rd list list?
>
> So:
>
> List A
> 1
> 2
> 3
>
> List B
> A
> B
> C
>
> List C
> Yes
> No
>
> If Yes > List A
> If No > List B
>
> Bart
> Excel 2003
>