How to do dependent variable drop down lists without using list names.

Hi all,

I need help in tracking my dockets from sub-contractors. In the spreadsheet attached, i would like to be able to enter in the docket number but then select the company from a drop down list which is taken from a list in the contract items tab, this part i can do no problem. What i then require though is that the drop down list for the contract item show only the items relevant to that company as i have possibly hundreds of items with all the subcontractors. The rate is then just achieved using a Vlookup statement. is there an easy way to do this or is my set out of data wrong? i would like to keep the list for contract items as it is as it makes finding the rate and adding in new items very easy.

thanks


Docket tracker.xlsxDocket tracker.xlsx