lordromias
New Member
- Joined
- Jun 15, 2018
- Messages
- 1
I hope you can help. I am trying to create a workbook where I can see on Sheet 1 a list of those who are attending specific courses depending on what I choose from the drop down. The course names populating the drop down (via data validation) are chosen from the top row on Sheet 2. I would be grateful if anyone can suggest a formula i.e. using index/match to use in Sheet 1 to pull the data through. I may need helper columns but have tested various methods and would appreciate any assistance.
Sheet 1
<tbody>
</tbody>
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
Sheet 1
Course 1 (Dropdown) |
<tbody>
</tbody>
Forename | Surname |
John | Andrews |
Mary | Jones |
<tbody>
</tbody>
Sheet 2
Forename | Surname | Course 1 | Course 2 | Course 3 |
John | Andrews | Y | N | Y |
Adam | Morris | N | Y | N |
Mary | Jones | Y | Y | N |
Jane | Smith | N | N | N |
<tbody>
</tbody>