Hello everyone,

I have a Journalism convention coming up, and we have several schools that register to compete in several competitions.
I was trying to create a Google form to lookup from a master competition list and match the school publication with the contest they enter and pull the students' name that is entered in the competition.

I'm trying to expedite the certificate printing process and avoid typos.
After the list gets compiled, I was going to merge with an award template and print all certificates at one time.

I have shared a link to my excel file.. Can anyone help?