Excel 2007 : Return Multiple Matches

Ok i just got done reading about 40 posts with similar titles, but non of them seem to really have anything to do with returning multiple matches.

so i have a list of LOCATIONS in column A

a list of PART Numbers in column B

and the QTY in column C.

sometimes the locations have the same part number. I have a search feature set up, i can look them up one by one and it auto filters but i would like to be able to make a list of everything i need, and it return the all the locations a certain part number is in.

=INDEX(SWITCH!$A$1:$B$600,SMALL(IF(SWITCH!$A$1:$A$600=$A$2,ROW(SWITCH!$A$1:$A$600)),ROW(1:1)),2)

i tried this but i dont really know what the hell it means.