hello!
This is my first post so please bare with me. I am trying to make a configurator for work. Here is what I'm trying to do:
B22 is a Drop down list made from Data validation. This list contains different types of equipment that is placed on different Chassis. I want to be able to click the drop down list, choose an aerial device and have a list of options be populated in B23--> B56. I have over 50 types of aerial devices so I would have 50 different option lists that data would be pulled from. I feel VLOOKUP would not work in this matter because the information is pulled from another worksheet and the data is in 1 column and several rows and I do not want to reinvent the wheel here. I feel that Match index MIGHT be what I need to do but I don't know how I need to go about using it. Any help would be greatly appreciated!
This is my first post so please bare with me. I am trying to make a configurator for work. Here is what I'm trying to do:
B22 is a Drop down list made from Data validation. This list contains different types of equipment that is placed on different Chassis. I want to be able to click the drop down list, choose an aerial device and have a list of options be populated in B23--> B56. I have over 50 types of aerial devices so I would have 50 different option lists that data would be pulled from. I feel VLOOKUP would not work in this matter because the information is pulled from another worksheet and the data is in 1 column and several rows and I do not want to reinvent the wheel here. I feel that Match index MIGHT be what I need to do but I don't know how I need to go about using it. Any help would be greatly appreciated!