If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Index/Lookup Function?
Hi All- I need help returning a list of names on a separate sheet. I'll
enter "manager 1" in an input cell, and i want to return a list of corresponding sales reps until i run out. I am not sure which formula is best: Index, Lookup etc. A B manager 1 sales rep 1 manager 1 sales rep 2 manager 1 sales rep 3 manager 2 sales rep 4 manager 2 sales rep 5 thanks! |
#2
|
|||
|
|||
Index/Lookup Function?
hi,
you may refer to my article at the following website - http://office.microsoft.com/en-us/ex...260381033.aspx -- Regards, Ashish Mathur Microsoft Excel MVP "jackie" wrote in message ... Hi All- I need help returning a list of names on a separate sheet. I'll enter "manager 1" in an input cell, and i want to return a list of corresponding sales reps until i run out. I am not sure which formula is best: Index, Lookup etc. A B manager 1 sales rep 1 manager 1 sales rep 2 manager 1 sales rep 3 manager 2 sales rep 4 manager 2 sales rep 5 thanks! |
#3
|
|||
|
|||
Index/Lookup Function?
I am not sure which formula is best: Index, Lookup etc.
None. Pivot table is the best option "jackie" wrote: Hi All- I need help returning a list of names on a separate sheet. I'll enter "manager 1" in an input cell, and i want to return a list of corresponding sales reps until i run out. I am not sure which formula is best: Index, Lookup etc. A B manager 1 sales rep 1 manager 1 sales rep 2 manager 1 sales rep 3 manager 2 sales rep 4 manager 2 sales rep 5 thanks! |
#4
|
|||
|
|||
Index/Lookup Function?
Is the data sorted or grouped together by manager as is shown in your sample
data? -- Biff Microsoft Excel MVP "jackie" wrote in message ... Hi All- I need help returning a list of names on a separate sheet. I'll enter "manager 1" in an input cell, and i want to return a list of corresponding sales reps until i run out. I am not sure which formula is best: Index, Lookup etc. A B manager 1 sales rep 1 manager 1 sales rep 2 manager 1 sales rep 3 manager 2 sales rep 4 manager 2 sales rep 5 thanks! |
#5
|
|||
|
|||
Index/Lookup Function?
Although there are formulae routes, I'd not dismiss the ease of a pivot table
(in the "separate sheet" that you specify). Assume the col headers of your source data a Mgr, Rep. In Layout, drag n drop Mgr into PAGE area, Rep into both ROW & DATA areas (set to Count). Click to Finish off the wizard. And that's it. Go to the pivot sheet, just click to "filter" the Mgr droplist created by any manager to surface the corresponding list of sales reps below .... -- Max Singapore --- "jackie" wrote: Hi All- I need help returning a list of names on a separate sheet. I'll enter "manager 1" in an input cell, and i want to return a list of corresponding sales reps until i run out. I am not sure which formula is best: Index, Lookup etc. A B manager 1 sales rep 1 manager 1 sales rep 2 manager 1 sales rep 3 manager 2 sales rep 4 manager 2 sales rep 5 thanks! |
Thread Tools | |
Display Modes | |
|
|