Hi guys, I'm very deep in a sheet and for dumb reasons I needed to put 2 different part numbers in the same cell. Is there a way to XLOOKUP or INDEX/MATCH one cell to a specific 'word' in another cell and spit it out like in the red? I am so lost on this. Thank you!
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Part Number | Brand | |||||
2 | 5050-01 5050-02 | Ford | Key | Result | |||
3 | 5050-01 5050-02 | Chevrolet | 5051-02 | Ford, Chevrolet | |||
4 | 5051-01 5051-02 | Dodge | |||||
Sheet1 |