Script that searches for a value in given arrays?

Question

Google Apps Script

There are two sheets. Sheet 2 - The value to be found and inserted on the trace. column desired values. Sheet2 Search range for these values. Search conditions - Value name and Maximum date. Result Status.

Spreadsheet with example: https://docs.google.com/spreadsheets/d/1_aIBHD6Xol...

Answer 1

It is not clear what exactly is needed, but the FILTER function will definitely help you (range; condition1; [condition2; ...])