Would DataFilterAutofilter be of any assistance?


Gord Dibben MS Excel MVP

On Tue, 18 Aug 2009 08:44:01 -0700, Wh0o
wrote:

I have a spreadsheet with a list of names numbers and emails. I am trying to
create that I would be able to type in the last name to a cell and it will
retrieve that rows information. The problem I am running into is that I am
only familiar with Vlookup and that only returns the first match that it
finds even though there may be 3 Williams on the list. Please use the
example below for your answer as I am new to excel..

A B C
1 Wallace Will 555-5555
2 Williams John 555-5555
3 Williams Carl 555-5555
4 Williams Marc 555-5555

I wouls appreciate and help with this.