I'm trying to figure out how to search a table in a spreadsheet using a variable column and returning a value from a different column.
More specific: teacher enters a period that they need coverage into a google form; form fills in spreadsheet; function needs to look at the column (could be a row if necessary) in the master schedule that is the period the teacher needs coverage looks for a teacher that is free that period (table is, at present populated with 1s and 0s, with 0 meaning free to keep it simple) function returns the name and/or email of the teacher (from a different column or row) that is free for formMule to send an email asking that teacher to cover the period. I've tried various functions and can't get the correct value return. Does anyone know how to do this or know of a script that does this. Thanks in advance! O' -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
