VLOOKUP and Data Validation

Hello all!

Its been a long time becuase of all your useful help!

however I am at a quandry and I need your assistance.

What I am doing:

I am making a Custodian form for customers based on what software they buy -- each item is categorized as a CLIN Item (X005, X006, etc) Each of that number corresponds to a specific Microsoft Software, however the customer needs to give me the correct Version. So in order to make that easier, I made a drop down menu on the next column to let the customer choose which version they ordered.

currently I just have a default software list of all the CLINS and I just go through the list and delete what I dont need for each customer, as my CLIN list gets bigger it just becomes more of a hassle.



I divided my spreadsheet into two worksheets 1) MAIN 2)DATA

I uploaded the form for you to check out.

Thanks ahead of time!

I successfully used VLOOKUP so when I put the CLIN number in (COlumn A) that it shows me the type of software (Column B), however when I try Vlookup to use on the drop down menus -- it does not work.

Is there a way around it?



I successfully used VLOOKUP so when I put the CLIN number in Column A, the Type of Software Shows up in COLUMN B