I am not certain that I have interpreted correctly. So I am guessing somewhat.
In column I of sheet2 I made a list of unique car IDs. They are the data validation list for the new drop downs in column C of sheet1.
In cell J2 of sheet2 I array-entered this formula and filled / copied down and across to K39:Array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
Referencing the array range in sheet2 I redefined the drop down validations in column D of sheet1 to in Data Validation Manager Source text box.
Now when you select a car ID in column C the drop downs in column D are limited to those drivers assigned to that car.
Does this do what you want?
And I must ask: Though your profile says Excel 2003 your uploaded file is an *.xlsx file. If backwards compatibility is to be considered my array formula in sheet2 will need to be reworked. Excel 2003 does not recognize the IFERROR function. Do you require backwards compatibility?
The file is attached.
Bookmarks