Good afternoon
I have a workbook that I am attempting to make drop down boxes in that allows a user to go in and select item one (DIV), then have the next drop down box give the options based on item one, as item two (BILLTO). Based on the selection in item two, the next box would return the LEVEL for item two. I have figured out how to make a cell calculate the appropriate LEVEL based on what is in item two BILLTO (using VLOOKUP). What I can not get is the DIV to be selected, The BILLTO to be a drop down selection option based on the DIV, then the LEVEL populate based on BILL TO. If this is something that can be done, please let me know how to do so, or direct me where I can go to find this solution. I have attached the root information in case this will help.
Thank You

On Wednesday, November 14, 2012 1:26:48 PM UTC-8, matgriffey wrote:
Good afternoon

I have a workbook that I am attempting to make drop down boxes in that

allows a user to go in and select item one (DIV), then have the next

drop down box give the options based on item one, as item two (BILLTO).

Based on the selection in item two, the next box would return the LEVEL

for item two. I have figured out how to make a cell calculate the

appropriate LEVEL based on what is in item two BILLTO (using VLOOKUP).

What I can not get is the DIV to be selected, The BILLTO to be a drop

down selection option based on the DIV, then the LEVEL populate based on

BILL TO. If this is something that can be done, please let me know how

to do so, or direct me where I can go to find this solution. I have

attached the root information in case this will help.

Thank You





+-------------------------------------------------------------------+

|Filename: Help Test.zip |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=686|

+-------------------------------------------------------------------+







--

matgriffey

Hi matgriffey
Take a look at these sites for dependent drop downs.

http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlDataVal02.html
http://excelsemipro.com/2011/05/a-dy...list-in-excel/

HTH
Regards,
Howard

Thank you very much for your assistance Howard. I appreciate the information. Have a great day.
Mathew