select From dropdown and return another dropdown menu

[RE4379]

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

 

[FSt1]

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

regards
FSt1

 

[cp402]

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

for Data Validation and INDIRECT function see here:

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 here:

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