W
Wh0o
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.
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.