On Sheet1 I'm attempting to create a drop down in CELL C3 that is dependent on the drop down selection in the cell to its left. Once the option in column C is selected, it will pull in the information from the sheet labeled ASSET ID and populate the cells to the right of it.. I hope this makes sense..

I'm trying to minimize the amount of manual updating and inputting that is required for people to maintain this asset tracker.


Test_Tracker_v2.xlsx