Skip to content

Instantly share code, notes, and snippets.

View JosephDomenici's full-sized avatar

JosephDomenici

View GitHub Profile
@JosephDomenici
JosephDomenici / Matches.gs
Created June 22, 2019 18:37
Custom Sheets function that finds an exact match on multiple columns and conditions
/**
* Finds an exact match on multiple columns and conditions. This function accepts an indefinite number of match parameters to search against.
*
* @param {"Foo"} value1 The first value to look up.
* @param {Sheet1!A:A} range1 The first range to match against.
* @param {"Bar"} value2 (optional, repeating) The second value to look up.
* @param {Sheet1!B:B} range2 (optional, repeating) The second range to match against.
* @return {Array} Row numbers of rows that exactly match on all conditions.
* @customfunction
*/