multiple vlookup options... again!

[AceFI]

hi all..
i know this has been done to death.. and even by me... however hoping for a solution...
I have this table;

Client	Staff Member
a	max
b	robert
c	charles
d	charles
e	charles
f	robert
g	robert
h	max
i	max
j	robert
k	robert
l	max
m	charles
n	Clint
o	Steve
p	Max

<colgroup><col width="87" span="3" style="width: 65pt;"></colgroup><tbody>
</tbody>

what i'm hoping to output is a report to show which client belongs to who;
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}tr {mso-height-source:auto;}col {mso-width-source:auto;}br {mso-data-placement:same-cell;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {font-weight:700;}--></style>

Max	Robert	Charles	Steve	Clint
a	b	c	o	n
h	f	d
i	g	e
l	j	m
p	k

<!--StartFragment--> <colgroup><col width="87" span="5" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

TIA

 

[AhoyNC]

This is an array formula that must be entered with CTRL-SHIFT-ENTER.
Drag formula down and across as needed.

Excel Workbook
	A	B	C	D	E
1	Client	Staff Member
2	a	max
3	b	robert
4	c	charles
5	d	charles
6	e	charles
7	f	robert
8	g	robert
9	h	max
10	i	max
11	j	robert
12	k	robert
13	l	max
14	m	charles
15	n	Clint
16	o	Steve
17	p	Max
18
19
20	Max	Robert	Charles	Steve	Clint
21	a	b	c	o
22	h	f	d
23	i	g	e
24	l	j	m
25	p	k
26
Sheet

 

[AceFI]

thanks. If i didn't want the results in a table, but wanted the results to if sales person = A20, then would i delete all after the first a20?

 

[AhoyNC]

You would just drag the formula down and enter the sales person name you want in cell A20.