I am looking for an excel function/formula that will return an array. I would like to return a block of cells and the data in them.
Ultimately, I am trying to build a simple parts builder. My idea is to build a master list of all parts w/ their corresponding subparts.
Part XYZ
- component 1
- component 2
- component 3
Part ABC
- component 4
- component 5
Once this list is built, I would like to be able to input Part XYZ and return the array of components that make up that part.
I am building this from scratch, so it may be easier to do in Access, but would appreciate any suggestions.
Thanks in advance
Zach
Bookmarks