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

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

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