Excel - Help on VLOOKUP Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a spreadsheet that lists customers. Column A row 2 has an entry of 1 and goes all the way up to 418. Column B is a list of Customers. Columns C, D, E are the employee ID associated to each customer. I am having a hard time creating vlookup to pull all customers associated to one specific employee id# related to multiple clents for that employee's ID. Please help.
Solved by C. U. in 43 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 13/12/2017 - 05:52
Hello!
Excelchat Expert 13/12/2017 - 05:52
can i see the sheet in which you want to apply vlookup?
Excelchat Expert 13/12/2017 - 05:54
there?
Excelchat Expert 13/12/2017 - 05:58
are you there?
User 13/12/2017 - 05:58
yes
User 13/12/2017 - 06:02
I would like to create a vlookup to extract all clients belonging to Max's id number
Excelchat Expert 13/12/2017 - 06:02
ok please wait let me check it
User 13/12/2017 - 06:02
on separate spreadsheet
User 13/12/2017 - 06:03
in sheet 2
Excelchat Expert 13/12/2017 - 06:03
ok
Excelchat Expert 13/12/2017 - 06:03
please wait
User 13/12/2017 - 06:04
no problem
Excelchat Expert 13/12/2017 - 06:09
you want to extract all the clients associated with max right?
User 13/12/2017 - 06:10
yes
Excelchat Expert 13/12/2017 - 06:10
this can not be done using vlookup i am creating another array formula please wait
User 13/12/2017 - 06:11
Ok thanks
Excelchat Expert 13/12/2017 - 06:21
hello
Excelchat Expert 13/12/2017 - 06:21
can you tell me how many sales rep are there?
User 13/12/2017 - 06:22
just those three
Excelchat Expert 13/12/2017 - 06:22
ok
Excelchat Expert 13/12/2017 - 06:33
i am so sorry sir
Excelchat Expert 13/12/2017 - 06:33
i have tried many methods
Excelchat Expert 13/12/2017 - 06:34
but i am unable to do this
Excelchat Expert 13/12/2017 - 06:35
are you there?

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.