I am working on using Google Spreadsheets as a gradebook. I am attempting to display only a student's grade, not an entire classes. I am integrating this into my wordpress site. The function I want to use will grab the logged in user's email and then look up that email in the spreadsheet and display Column A and whatever column their email is in.
I found the following code, which I think is a start. I can use a PHP function to get the user email address (rather than a search string) but this only displays the row the email is in. How can I get it to display only the column?
Here is the pastepin of the code I have been playing with: