unlimitedVlookup

Overview
Vertical lookup using unlimited elements to find an output
This custom function is still on beta and can fail during its execution
Video Example
Arguments
matrix: Data to search in
index: Column where the to find the data
firstItem: First item to match
args: The rest of items to match
Expected Output
String: The string matched with the specified criteria
Text example
unlimitedVlookup(A1:D8, 5, "value 1", "value 2", "value 3")
// Will return "value 4", the one next to "value 3"
Use cases
Look up a value related to an unlimited set of other elements

Last modified 7mo ago