Hi guys,
I have a bit of a strange one. I have obtained data from a survey from different teachers for different students in one class. Google Forms pushes the data out across multiple columns and rows similar to that below (obviously with more questions):
I was wondering if there was a way that I could extract the data for each one of the different sections according to the collated data and have it displayed in the sheet (please see attached file) for hopeful output as well (I have used Data Validation for a list of student names) and hoping it can check the name and give out the appropriate data.
I am aware that VLOOKUP and HLOOKUP only do horizontal or vertical, they don't look across a range of cells.
Also not sure if pulling the data from different sheets will cause an issue.
If anyone could assist, I would greatly appreciate it.
Thanks!
Bookmarks