Hello,
I need assistance in creating a formula/string to return all location results (into individiual cells) based on search criteria. Please see example.

Location Item Item Item
A 100 400
B 400
C 400 100
D 300
E 200 100
F 200
G 100
H 100 300
I 200 300 100
Search Results
100 A C E G H I
200 E F I
300 D H I
400 A B C

Thank you in advance!