I have two columns:
Column A Column B
1 Course ID Professors <---- (Column Headers)
2 1179/03 Professor-1
3 1179/03
4 1179/03
5 1300/20 Professor-2
6 1300/20 Professor-3
7 1300/21 Professor-2
8 1300/21 Professor-3
9 1300/21 Professor-4
10 1300/21 Professor-4
11 1300/21 Professor-4
Where, to each Course ID can be multiple Professors assigned.
In another part of the same sheet I have a list of Course IDs and I want to insert the assigned professors by means of a formula:
Column D Column E
1 Course ID Professors <--- (Column Header)
2 1179/03 Professor-1
3 1300/20 Professor-2, Professor-3
4 1300/21 Professor-2, Professor-3, Professor-4
I will manually provide the data in the A, B and D columns, then I want to get the results in the E2, E3, E4 by means of Match/Index
or VLOOKUP
.
My limit is that, I am not able to add any new column, and possibly, restrict users to sort data according to a certain column.
Can anyone help me, please.