One List for LookUp - Need All Results

[mscheid]

Hello,

I'm in need of some help regarding Excel and lookups functions.

My worksheet contains 2 tabs.

Tab 1 - Contains Employee Names and Projects they're on.
Note * Their names may be listed multiple times. (Once for each project)

Example -

Joe Smith Project 1
Bob White Project 1

Joe Smith Project 2
Jane Doe Project 2




Tab 2 - List of all employee names (each only listed once)

What I need to do, is perform a look up on the employees name in tab 2, and create a list in cells under their name of each project they're on.

Result Example -

Joe Smith
Project 1
Project 2

Can anyone help me do this with a function? I've been trying Indexes and Matches and I can't seem to get them to work.

Thank you for your help in advance!!

 

[JasonMac]

how is the data in the excel sheet? like is column A for names and column B for Projects? Becasue if it is you can use a loop, search tab 1 column A for name that = tab 2 cell with the name in it. if it matches then copy the project over to tab2. Any ways baiscally if you can give me an outline of how the data is on the sheet i can give you a more in depth response!

 

[mscheid]

Hi, Thanks for your reply! Below is a very basic version of the xls tabs.

Tab 1 -

A B
1 John Smith Project 1
2 Jane Doe Project 1
3
4
5 John Smith Project 2
6 Bob White Project 2

Tab 2 -

A
1 John Smith
2 Jane Doe
3 John Smith
4 Bob White

What I would like to accomplish is
A B
1 John Smith
Project 1
Project 2
2 Jane Doe Project 1

and so on.

Thanks!!! Let me know what you think.

Ok this doesn't post well, so I'll explain rather than provider examples.

Tab 1 Column A = Employee Name
Column B = Project Name

Tab 2 Column A = Employee Name
Column B = Would like to list all applicable projects

Let me know if this helps!!

Thanks again!!!

 

[swst]

Use a pivot table
This would give you what you want

Steve