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
<tbody>
</tbody>
List of all Type 2 Booking Dates:
<tbody>
</tbody>
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
Name | Type | Booking Date | ||
Joe | Type 1 | 01/01/2018 | ||
Joe | Type 2 | 06/08/2018 | ||
Karen | Type 1 | 01/02/2018 | ||
Ann | Type 2 | 03/02/2018 | ||
James | Type 1 | 20/08/2018 | ||
Ann | Type 1 | 31/08/2018 | ||
Helen | Type 1 | 01/01/2018 | ||
Helen | Type 2 | 09/01/2019 | ||
Helen | Type 3 | 02/03/2019 |
<tbody>
</tbody>
List of all Type 2 Booking Dates:
Name | Booking Date |
Joe | 06/08/2018 |
Karen | - |
Ann | 03/02/2018 |
James | 20/08/2018 |
Helen | 09/01/2019 |
<tbody>
</tbody>