How can I add a conditional statement (similar to an if elseif
in .php) to the query listed below so that is will return columns D and E from Sheet2 if column C in the responses sheet == 1st or columns F and G if from Sheet2 if column C in responses sheet == 2nd? It must work within the =QUERY
so it only returns column data from the appropriate row (based on the query).
=QUERY(Sheet2!$A$1:K; CONCATENATE("SELECT B, C WHERE A = ", responses!B1), 0)
I looked into IF(OR)
, but I don't believe that will work because final project will have more than two possibilities (there will actually be eight, 1st through 8th class period).
Here is a link to the Google Spreadsheet I'm working with.
Any suggestions?
Best Answer
The following formula will display the corresponding teachers.
Formula
Explained
The
SIGN
and theROW
function are there to meet up with the criteria, set with using anARRAYFORMULA
. It will return an equally long array as setout in the search_condition. TheIF
function sets the condition for the index, by using the test.Screenshot
Example
I've copied your file and added my solution to it: teacher references