I have an address list in one worksheet with: Last Name, First name, Address,
City, phone No. These addresses are sort alphabetically by last name.
On another worksheet I am attempting to match data from the first sheet
using the VLOOKUP function.
PROBLEM:
If there are three people with the same last name (e.g. "Brown"), but they
have different first names (e.g. "Peter", "John", "Susan"), and they live at
three different addresses, the LOOKUP function only returns the First name,
Address etc. of the first person on the list (e.g. "John"). If I try to
expand the search for both last name and first name I get an error message.
Any help would be appreciated