Adding points from one sheet to another [Solved/Closed]

Julia - Aug 31, 2016 at 03:25 AM - Latest reply: TrowaD 2348 Posts Sunday September 12, 2010Registration dateModeratorStatus April 24, 2018 Last seen
- Sep 1, 2016 at 11:07 AM
Hello,

I'm trying to record points that students accumulate in a club.

In a GoogleForm, I check off the students (Estudiantes) that earned x points (# de puntos) and also indicate what event they earned the point at (Nombre del evento). That goes to "Form Responses 1".

Now, in "Form Responses 2" I want to be able to see the number of points that particular student has and the name of the event where they earned the point(s). But the students are listed among many different student names in the "Estudiantes" column of "Form Responses 1".

I imagine this involves an IF formula, but I imagine it involves so much more, too and I'm totally lost. Images below!

Any help? THANK YOU SO SO MUCH.
See more 

2 replies

ac3mark 9220 Posts Monday June 3, 2013Registration dateModeratorStatus April 25, 2018 Last seen - Aug 31, 2016 at 05:54 PM
0
Helpful
You really need a database table to query and report on.
TrowaD 2348 Posts Sunday September 12, 2010Registration dateModeratorStatus April 24, 2018 Last seen - Sep 1, 2016 at 11:07 AM
0
Helpful
Hi Julia,

Seems to me you are in need of the VLOOKUP formula, but you forgot to post the mentioned images. What would help is to show how it looks now and how you want it to look.

Best regards,
Trowa