I am creating a workbook for my specific unit in regards to active vehicles. In column B(Sheet 2) I have Year Make and Model. In column C I have the VIN number. I used Data Validation on the second tab with all the makes we own/use. I named the range on the first work sheet to use only the listed makes as a drop down menu in Column B(first sheet). Now, I want to have the VIN auto populate in column C (first sheet)when a certain vehicle is choosen. I am stuck!vin TEST.xlsm