A
A
Alexander2016-08-25 08:44:38
Google Sheets
Alexander, 2016-08-25 08:44:38

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

1 answer(s)
A
Alexander, 2016-09-06
@talesforyou12

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 question

Ask a Question

731 491 924 answers to any question