Hi Everyone,

I'm stuck up with a problem here and I hope I'll get some help here. I want
a conditional validation done on one of my cells. This is how it goes. I'm
working on a report that spans multiple teams across multiple locations. The
person running the report will have to select the location from a list
validation. Now, based on the location selected, I want another list
validation for the team field. This list should carry only the teams active
in the selected location. Is there any way this can be done without involving
programming?

Thanks,

Sam

Sounds like you could use the Dependent List validation approach which you
can find about here...

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

I would imagine you'd be able to then generate named ranges for locations
and teams. Then using the INDIRECT function you should be able to change the
validation done on the team cell based on the location that's chosen.

George.

"The Narcissist" wrote:

Hi Everyone,

I'm stuck up with a problem here and I hope I'll get some help here. I want
a conditional validation done on one of my cells. This is how it goes. I'm
working on a report that spans multiple teams across multiple locations. The
person running the report will have to select the location from a list
validation. Now, based on the location selected, I want another list
validation for the team field. This list should carry only the teams active
in the selected location. Is there any way this can be done without involving
programming?

Thanks,

Sam

Thanks George. That worked for me. :)


"George" wrote:

Sounds like you could use the Dependent List validation approach which you
can find about here...

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

I would imagine you'd be able to then generate named ranges for locations
and teams. Then using the INDIRECT function you should be able to change the
validation done on the team cell based on the location that's chosen.

George.

"The Narcissist" wrote:

Hi Everyone,

I'm stuck up with a problem here and I hope I'll get some help here. I want
a conditional validation done on one of my cells. This is how it goes. I'm
working on a report that spans multiple teams across multiple locations. The
person running the report will have to select the location from a list
validation. Now, based on the location selected, I want another list
validation for the team field. This list should carry only the teams active
in the selected location. Is there any way this can be done without involving
programming?

Thanks,

Sam

Great. I've had so much help from this discussion group it's about time I
contributed back into the knowledge :-)

"The Narcissist" wrote:

Thanks George. That worked for me. :)


"George" wrote:

Sounds like you could use the Dependent List validation approach which you
can find about here...

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

I would imagine you'd be able to then generate named ranges for locations
and teams. Then using the INDIRECT function you should be able to change the
validation done on the team cell based on the location that's chosen.

George.

"The Narcissist" wrote:

Hi Everyone,

I'm stuck up with a problem here and I hope I'll get some help here. I want
a conditional validation done on one of my cells. This is how it goes. I'm
working on a report that spans multiple teams across multiple locations. The
person running the report will have to select the location from a list
validation. Now, based on the location selected, I want another list
validation for the team field. This list should carry only the teams active
in the selected location. Is there any way this can be done without involving
programming?

Thanks,

Sam