vlookup parent and bring back children values

nsipo

I'm trying to do a vlookup of a part and return all of the child rows into another sheet, see attachment. In another sheet, I want to type in "CA240T" and for the child rows to be populated. Is this possible?

Image 9-11-24 at 4.16 PM.jpeg

NicoLHC

@nsipo maybe it easier to use index match or collect instead of vlookup & add the child formula.