I am looking for code or formula. I have a very large spreadsheet with over 200 items. Each item can be classified as 1 of 11 different subtypes and each subtype has its own properties. How do I classify item 1 is a "Type 11" and roughly 20 cells to the right of the "Type 11" will automatically populate with Type 11 properties.

I have included a pdf of what I am looking to do. The "Axis No./ Name" will be entered manually. The "Model Version" will be a drop down list. And all other information i would like to populate based solely on "Model Version".

Thank you for your help.