I have created a google form for an event registration. I am now try to create an excel spreadsheet that sorts the information from one sheet to another. I don't know if my question is clear. I think I am not sure what questions to ask because I don't know what options are available. I have done something similar to this with a smaller amount of information and this is the formula I used.
=IF('R1 - R'!$B$3=E2,'R1 - R'!$A$3, IF('R1 - R'!$B$4=E2,'R1 - R'!$A$4,IF('R1 - R'!$B$5=E2,'R1 - R'!$A$5,IF('R1 - R'!$B$6=E2,'R1 - R'!$A$6,IF('R1 - R'!$B$7=E2,'R1 - R'!$A$7,IF('R1 - R'!$B$8=E2,'R1 - R'!$A$8,IF('R1 - R'!$B$9=E2,'R1 - R'!$A$9,IF('R1 - R'!$B$10=E2,'R1 - R'!$A$10,IF('R1 - R'!$B$11=E2,'R1 - R'!$A$11,)))))))))
Is there anything any simpler or faster?
Bookmarks