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