I have data where individual names are listed in Column A. In Row 1 are different meeting names. Data is listed in cells B3:D6, where all the data is the number 1 indicating that a person has attended that meeting.
I have individual sheets for each person and would like the person's sheet to show which meetings they have attended.
Ie - John Smith has attended Meeting 1 and Meeting 3. Freda Fox has attended all meetings.
I cannot seem to work out the formula to get excel to lookup the name of person in Cell B1 of their individual sheet and then return the header of the first 1 it finds and then return the header of the second 1 it finds etc.
I have tried INDEX MATCH, VLOOKUP, Reverse LOOKUP but have struggled to find the correct combination. Any help would be appreciated.
I have individual sheets for each person and would like the person's sheet to show which meetings they have attended.
Ie - John Smith has attended Meeting 1 and Meeting 3. Freda Fox has attended all meetings.
I cannot seem to work out the formula to get excel to lookup the name of person in Cell B1 of their individual sheet and then return the header of the first 1 it finds and then return the header of the second 1 it finds etc.
I have tried INDEX MATCH, VLOOKUP, Reverse LOOKUP but have struggled to find the correct combination. Any help would be appreciated.