Answer the question
In order to leave comments, you need to log in
How to make a selection by value from another sheet in a google spreadsheet?
I use google form to fill out questionnaires by consumers. The data from the form comes in the form: "08/03/2016 12:12:47; Kulichenko Ya.Yu.;Yes;". When trying to find by the value "=VLOOKUP("Kulichenko Ya.Yu.";'Answers to the form (6)'!B1:C102; 2; FALSE)", the formula works correctly and displays "Yes". But I would like to search by the date the form was filled, and when I try to find "=VLOOKUP("08/03/2016 12:12:47 PM";'Responses to the form (6)'!B1:C102; 2; FALSE)", either "=VLOOKUP("08/03/2016";'Responses to form (6)'!B1:C102; 2; FALSE)" error #N/A#(No value found in vlookup range)
Answer the question
In order to leave comments, you need to log in
Here is the solution:
=IFERROR(IF(INDEX('Responses to form (5)'!$F:$F;MATCH("Togliatti"&DATE(2016;9;2);'Responses to form (5)'!$B :$B&'Responses to form (5)'!$C:$C;0))="Yes";1;INDEX('Responses to form (5)'!$F:$F;MATCH("Togliatti" &DATE(2016;9;2);'Responses to form (5)'!$B:$B&'Responses to form (5)'!$C:$C;0))))
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question