1 | Student ID | Grade | spreadsheet locale | post in Google Docs user forum by Mark Gunkel and question by Saylom Saenbandith | |||
|---|---|---|---|---|---|---|---|
2 | 42423423 | no such Student ID | United States | no such Student ID | FALSE | ||
3 | |||||||
4 | this is cell C4 | ||||||
5 | formula in cell A1 for cella A1:A2 | ||||||
6 | =query('Form Responses 1'!A:B,"select B order by A desc limit 1") | ||||||
7 | and | ||||||
8 | formula in cell B2 | ||||||
9 | =vlookup(A2,GradeSheet!B:C,2,0) | ||||||
10 | |||||||