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

Last updated