dinesh.sarsar
New member
- Joined
- Sep 8, 2014
- Messages
- 21
- Reaction score
- 0
- Points
- 0
- Location
- India, Maharashtra Pune
- Excel Version(s)
- MS OFFICE Windows 10
Hi,
I have a file in which sheet 1 has the data of Requirement ID in column A and the Candidate name in column B, the issue that i am facing is, when i use vlookup to pull the data from Sheet 1 column B, into Sheet 2 than as the requirement ID of 198 has got multiple names under it, I get the name of the first person multiple times in sheet 2. So is there any option where i can pull the data as mentioned in the expected result in sheet 2.
I have a file in which sheet 1 has the data of Requirement ID in column A and the Candidate name in column B, the issue that i am facing is, when i use vlookup to pull the data from Sheet 1 column B, into Sheet 2 than as the requirement ID of 198 has got multiple names under it, I get the name of the first person multiple times in sheet 2. So is there any option where i can pull the data as mentioned in the expected result in sheet 2.