Index match

[umasskid4]

Data:
A : B:
Wilbraham John Wagner (first row, row 1)
Wilbraham Casey Smith
Wilbraham Chris Kavanagh
Wilbraham Josh Gorman
Springfield Tom White
Springfield Elizabeth Crowl

I want to be able to lookup wilbraham and receive the the four names that correlate with it and then populate a text box with those four names. The lookup value would be "wilbraham" which is a value from "ComboBox1.Value" I am having a user select wilbraham on the combobox list and then this would search for the four names and display them on the textbox.


So the textbox on my spread would read like this
Town Names:
John Wagner
Casey Smith
Chris Kavanagh
Josh Gorman

I have been trying for hours, i got a Vlookup sucessfully going but realized it could only return the first name John Wagner. Now i'm trying to do a index-match but i'm lost.I feel like i was closer with the Vlookup as i successfully got John Wagner in the textbox and now my code just looks not even close.
I'd really appreciate any help!

first code for attempt at index match

Please Login or Register  to view this content.

[GC Excel]

Hi and welcome to the forum,

Here's a different approach. If it doesn't work please post a sample workbook:

Please Login or Register  to view this content.

PS: Your textbox "peopleList" must have the property "Multiline = True"