I have a somewhat long list of names in different columns with all of their info. What I need to do is find a way to lookup rows of info if I input a first name, or last name, or company name, etc. The problem I am having is that there is more than one person in the list with the first name john or the last name smith and other such names. I need to find a way to look up ALL records that contain the first name john and be able to pick which one is the right one rather than just finding the first one in the list.
The easiest way to deal with this would be combine first name with last name and lookup accordingly but the list was not put together well so some people don't have first names or last names or either (some just have company names).
Sorry for the long message but I guess my question is if you have a nice way of finding every record that matches a certain criteria rather than just the first one in the list. I have a much simpler worksheet that I made up that simulates the idea if you think that would help at all.