Search Results to Listbox
 

Please Help if you can
Column A has last name, first name
Say these names are in Column A
Column A Row
Hoover, John 6
Hoover, Rick 10
Hoover, Jordan 20

Does the Search, all 3 should come up in the list box/ComboBox/
Dropdown
Wichever is easiest,
Now when i Select Rick, I nee