So I have Sheet 1 which contains Client Name (Column A), Date 1 (Column B), Date 2 (Column C).
I then have Sheet 2 which contains individual dates in each cell under row A (A1 - 1/1/2017, A2 - 1/2/2017, A3 - 1/3/2017, etc).
I need a formula that searches through columns B and C on Sheet 1 and displays all Client Names that meet the specific date in the specified row. So if the client has the date 1/1/17, I want their name to display under row 1. I want ALL the clients that meet that specific date to display in the row.
I have included some sample tables to help explain what I'm trying to accomplish.
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
The order of the clients does not matter, but I would like columns B-K available for up to 10 clients to be inserted under one date. I tried to use a LOOKUP function but I would not be able to display multiple clients. I have a somewhat limited knowledge of Excel. Any help is appreciated. Thank you!
I then have Sheet 2 which contains individual dates in each cell under row A (A1 - 1/1/2017, A2 - 1/2/2017, A3 - 1/3/2017, etc).
I need a formula that searches through columns B and C on Sheet 1 and displays all Client Names that meet the specific date in the specified row. So if the client has the date 1/1/17, I want their name to display under row 1. I want ALL the clients that meet that specific date to display in the row.
I have included some sample tables to help explain what I'm trying to accomplish.
Sheet 1
Client | Date 1 | Date 2 |
Bob Smith | 1/1/2017 | 1/3/2017 |
Bill Jones | 1/2/2017 | 1/3/2017 |
Jane Johnson | 1/1/2017 | 1/4/2017 |
Jack Daniels | 1/1/2017 | 1/2/2017 |
<tbody>
</tbody>
Sheet 2
Date | Client 1 | Client 2 | Client 3 | Client 4 |
1/1/2017 | Bob Smith | Jane Johnson | Jack Daniels | |
1/2/2017 | Bill Jones | Jack Daniels | ||
1/3/2017 | Bob Smith | Bill Jones | ||
1/4/2017 | Jane Johnson |
<tbody>
</tbody>
The order of the clients does not matter, but I would like columns B-K available for up to 10 clients to be inserted under one date. I tried to use a LOOKUP function but I would not be able to display multiple clients. I have a somewhat limited knowledge of Excel. Any help is appreciated. Thank you!