hello,
must be having a brain fart... can't get a formula to work. I need to take multiple part numbers and pull in all the AVLs that are tied to each one. See example below...
so in cell A2 I would have a part number XYZ, XYZ has 4 approved manufactures. So I would want to pull in all the...