Validation Dependent list based on two other lists

[Queryman]

I have a list with 10 values in a cell, let's say cell A2, and another list with 8 values in the next cell B2, is it possible to have a third list in the adjoining cell C2 that will only have a list if specific values from list a and list b are chosen and no list if those specific values are not chosen.

I am trying to solve my problem posed in my earlier question in a different way.

Thanks



Michael

 

[GlennUK]

What are the possible values in validation list for a, and validation list b that when chosen activate a list for c, and what is the list for c?



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Queryman]

The values would be IN in A and OUT in B, c would have two values HERE and GONE if a and b have those values.

Thanks



Michael

 

[GlennUK]

OK, this is very easy to do.

Make a validation list im another part of the sheet, containing HERE and NOW in 2 cells. Do menu command Insert/Name/Define and define the range containing those 2 cells as IN_OUT.

Now for the drop-down list for c do Data/Validation/List and type this formula for the list source:
=INDIRECT(A2&"_"&B2)
this will probably give an error message of "The Source currently evaluates to an error. Do you wish to continue?" to which you respond Yes.

Now, there will be no drop-down until A is IN and b is OUT, at which time c will have a drop-down of HERE and NOW.



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.