multiple vlookup options... again!

AceFI

Board Regular
Joined
Apr 20, 2012
Messages
93
hi all..
i know this has been done to death.. and even by me... however hoping for a solution...
I have this table;

[TABLE="width: 261"]
<colgroup><col width="87" span="3" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="width: 87"]Client[/TD]
[TD="width: 174, colspan: 2"]Staff Member[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]max[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]charles[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]charles[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]charles[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]g[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]h[/TD]
[TD]max[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]i[/TD]
[TD]max[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]j[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]k[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]l[/TD]
[TD]max[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]m[/TD]
[TD]charles[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]n[/TD]
[TD]Clint[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]o[/TD]
[TD]Steve[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]p[/TD]
[TD]Max[/TD]
[/TR]
</tbody>[/TABLE]


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-ignore:padding; 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>[TABLE="width: 435"]
<!--StartFragment--> <colgroup><col width="87" span="5" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 87"]Max[/TD]
[TD="class: xl63, width: 87"]Robert[/TD]
[TD="class: xl63, width: 87"]Charles[/TD]
[TD="class: xl63, width: 87"]Steve[/TD]
[TD="class: xl63, width: 87"]Clint[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]o[/TD]
[TD]n[/TD]
[/TR]
[TR]
[TD]h[/TD]
[TD]f[/TD]
[TD]d[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]i[/TD]
[TD]g[/TD]
[TD]e[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]l[/TD]
[TD]j[/TD]
[TD]m[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]p[/TD]
[TD]k[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]


TIA
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
This is an array formula that must be entered with CTRL-SHIFT-ENTER.
Drag formula down and across as needed.
Excel Workbook
ABCDE
1ClientStaff Member
2amax
3brobert
4ccharles
5dcharles
6echarles
7frobert
8grobert
9hmax
10imax
11jrobert
12krobert
13lmax
14mcharles
15nClint
16oSteve
17pMax
18
19
20MaxRobertCharlesSteveClint
21abco
22hfd
23ige
24ljm
25pk
26
Sheet
 
Upvote 0
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?
 
Upvote 0
You would just drag the formula down and enter the sales person name you want in cell A20.
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,286
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top