vlookup with duplicates

sipsevents

I have a multi program summer symposium I'm working on and students sign up on one sheet to indicate which faculty they want to work with then i have another sheet where faculty write answers regarding each student.

I was using vlookup to match the sheets together on one, but students can sign up for multiple programs, so the single identifier i was using for vlookup (student email) will have duplicates, any suggestions on how to combine these two sheets without duplicates?

Meaning, I would like the end result to be if a student picks program A and faculty A, then it pulls that info from another sheet and combines it, and if that same student picks program B and faculty B then it pulls it again. hope this makes sense

thanks!

Julio S.

Hi @sipsevents ,

By the looks of it, JOIN(COLLECT()) could be the best way to accomplish what you intend. In my example below you can see how a list of students can reflect the multiple members of faculty they've chosen in the Faculty selection sheet by using the =JOIN(COLLECT({Faculty}, {Student}, Students@row), ", ") Column formula:

I hope that this can be of help! But if it isn't, please share some captures of your sheets layout so that I can possibly advise further. Please make sure to hide any sensitive information that you wouldn't like to share.

Cheers!

Julio

Julio S.

Hi @sipsevents ,

By the looks of it, JOIN(COLLECT()) could be the best way to accomplish what you intend. In my example below you can see how a list of students can reflect the multiple members of faculty they've chosen in the Faculty selection sheet by using the =JOIN(COLLECT({Faculty}, {Student}, Students@row), ", ") Column formula:

I hope that this can be of help! But if it isn't, please share some captures of your sheets layout so that I can possibly advise further. Please make sure to hide any sensitive information that you wouldn't like to share.

Cheers!

Julio

sipsevents

perfect, thank you so much!