Return associated data for all instances for employee ID number

[shoobootie]

Good afternoon, folks. Here's my structure and dilemma:

Column A: sorted, unique employee ID numbers
Column B: sorted, non-unique employee ID numbers that are associated with:
Column C: date
Column D: time

I want to create a formula to return the data in columns B, C and D each time column B matches column A. I've screwed around with =VLOOKUP(a1,b$1:d17116,1,false), but that only seems to return one instance and only the value in column B. Please see the attached file.

Thanks for your consideration!

Heather

[ChemistB]

Okay, you did not give an example of how you want this laid out.
In your example, there is a match for A17 (023317006) in B1930 and B1931.
Do you want the values from C1930, C1931, D1930 and D1931 in E through H17?

[shoobootie]

I was going with beggars can't be choosy about format, but the ultimate would be to have the returns on Sheet2 where row one would be B1930|c1930|d1930 and row two would be b1931|c1931|d1931. However, I will take it in any way that shows all instances of a match and the associated date and time info.

[ChemistB]

Would this work for you, since you already have Col B sorted by value so that duplicate/triplicate values will be in adjoining rows

First, insert a header row so you can filter later
In E2 (first row of data)
=IF(ISNUMBER(MATCH(B2,A:A,0)),"Y","N")
Copied down to the end of data
Then Filter on "Y" and only matching values will show.
Would that work for you?

[shoobootie]

That did the trick! For the rest of the day, people must refer to you as Super Genius. Thank you so much

[ChemistB]

Thanks Heather, I'll inform my co-workers.