Help with Vlookup in a Dependent drop down list
I am working on a project for work and trying to do something I have never done before. The best example would be if you were to log onto an auto parts website and choose your automobile and then the part you need. I am trying to do this with a spare parts list with numerous lifts. The list is only partial at the moment until I have the coding correct. Please assist as I have been working on this for a week and I am driving myself crazy.
I have attached the file so that you can see what I have come up with so far. I have the Comm/SN dependent upon the Model. Now I need the Parts and description dependent upon the Comm/SN.
Any help would be greatly appreciated!
Thanks,
Angel
|