vlookup with duplicates
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
Help Article Resources
Check out the Formula Handbook template!