lookup value if there are multiple matches

[annielise]

Hi there,

I have data that when i vlookup it only picks up the first value. What is the best way of being able to find the corresponding value in a different column if the criteria matches?

For example, i want to be able to find what all the Type 2 bookings are for the individuals. What formula would be best for this? Thanks!

Data Set

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Type
[/TD]
[TD]Booking Date
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Joe
[/TD]
[TD]Type 1
[/TD]
[TD]01/01/2018
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Joe
[/TD]
[TD]Type 2
[/TD]
[TD]06/08/2018
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Karen
[/TD]
[TD]Type 1
[/TD]
[TD]01/02/2018
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ann
[/TD]
[TD]Type 2
[/TD]
[TD]03/02/2018
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]James
[/TD]
[TD]Type 1
[/TD]
[TD]20/08/2018
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ann
[/TD]
[TD]Type 1
[/TD]
[TD]31/08/2018
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Helen
[/TD]
[TD]Type 1
[/TD]
[TD]01/01/2018
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Helen
[/TD]
[TD]Type 2
[/TD]
[TD]09/01/2019
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Helen
[/TD]
[TD]Type 3
[/TD]
[TD]02/03/2019
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


List of all Type 2 Booking Dates:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Booking Date
[/TD]
[/TR]
[TR]
[TD]Joe
[/TD]
[TD]06/08/2018
[/TD]
[/TR]
[TR]
[TD]Karen
[/TD]
[TD]-
[/TD]
[/TR]
[TR]
[TD]Ann
[/TD]
[TD]03/02/2018
[/TD]
[/TR]
[TR]
[TD]James
[/TD]
[TD]20/08/2018
[/TD]
[/TR]
[TR]
[TD]Helen
[/TD]
[TD]09/01/2019
[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

Try one of these.
If you have Excel 2010 or later you can use the formulas in cells D15 and E15 below.
Other wise you can use the formulas in A15 and B15. The formulas in A15 & B15 must be entered with CTRL-SHIFT-ENTER. Then drag down as needed.

Excel Workbook
	A	B	C	D	E
1	Name	Type	Booking Date
2	Joe	Type 1	1/1/2018
3	Joe	Type 2	8/6/2018
4	Karen	Type 1	2/1/2018
5	Ann	Type 2	2/3/2018
6	James	Type 1	8/20/2018
7	Ann	Type 1	8/31/2018
8	Helen	Type 1	1/1/2018
9	Helen	Type 2	1/9/2019
10	Helen	Type 3	3/2/2019
11
12
13	Find:	Type 2		Find:	Type 2
14	Name	Date		Name	Date
15	Joe	8/6/2018		Joe	8/6/2018
16	Ann	2/3/2018		Ann	2/3/2018
17	Helen	1/9/2019		Helen	1/9/2019
Sheet