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