I am trying to extrapolate data from a from response in forms/google sheets.

On the attachment, students can select 1, 2 or 3 in any of the columns. I then need the header of the 3 selections to be looked up on the second sheet in the correct column (reducing it down to everything just in the square bracket is a bonus).

This is an example, in the real thing there'd be more students in the list.

Thanks