select From dropdown and return another dropdown menu
 

Hi,

i am looking for help with dropdowns and returns. I would like to b able to
have staff select their business area from a dropdown menu, when a business
area is selected i would like it to then offer the corresponding cost codes
for that business area as a dropdown and those cost codes be available for
selection.

Is it possible?

many thanks in anticipation.

Nigel

select From dropdown and return another dropdown menu
 

hi
not sure but see if this is what you want
http://www.contextures.com/xlDataVal02.html

regards
FSt1

"RE4379" wrote:

Hi,

i am looking for help with dropdowns and returns. I would like to b able to
have staff select their business area from a dropdown menu, when a business
area is selected i would like it to then offer the corresponding cost codes
for that business area as a dropdown and those cost codes be available for
selection.

Is it possible?

many thanks in anticipation.

Nigel

select From dropdown and return another dropdown menu
 

1) By using a combination of Data Validation, INDIRECT, and VLOOK UP you can
complete this function:

for Data Validation and INDIRECT function see he

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

to use VLOOKUP to enter fixed data once you have created drop down list #1
and the second or additional dependent drop down lists see he

http://www.contextures.on.ca/xlFunctions02.html

"RE4379" wrote:

Hi,

i am looking for help with dropdowns and returns. I would like to b able to
have staff select their business area from a dropdown menu, when a business
area is selected i would like it to then offer the corresponding cost codes
for that business area as a dropdown and those cost codes be available for
selection.

Is it possible?

many thanks in anticipation.

Nigel