Hi, i have 2 spreadsheets that have different information but of the same people. So there is an ID number for each person in both sheets, but different information that they filled out at different time points. However, at some point, people dropped out between timepoints A and B. I am trying to combine those 2 sheets together and I have been using individual v-lookup functions, but I think index and match is a much better, quicker option (there are literally 100's of columns of answers from each person). I've been trying functions after watching youtube videos but I'm still having a hard time.
Solved by X. Q. in 13 mins