Retrieving multiple rows of data in an array

**Dadx6** · 06-11-2009, 12:26 PM

Hi all,

My problem is this:

I have a Contact list that is sorted similiar to the following,
Column:

Name - Address - Phone - Fax - Contact

Blah - 1234 Anywhere street - 555-1212 - 555-1313 - Dr. Jones - Dr. Bauer

A summary sheet fills in address/phone/fax based on Name. Name is presented to the user with a list box. Information filled in using vlookup. How can i retrieve the contact list (if there are multiple contact names) and present the user with a choice of the available contacts?

**starryknight64** · 06-11-2009, 12:34 PM

Try using another listbox (or even a combobox) and do a search within the table for the Name you selected (using a VB macro) and populate the listbox with the contacts you find for the Name you selected.

I hope this helps!

**Dadx6** · 06-11-2009, 12:41 PM

Im a veritable retard when it comes to using VB. Is there anyway to use an excel formula to solve this? Is it possible to re-sort the data in a manner that would allow me to use an excel formula?