Vertical lookup using unlimited elements to find an output
This custom function is still on beta and can fail during its execution

Video Example


  • 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