v2lookup

Overview

Vertical lookup using two elements to find an output

Video Example

Arguments

  • matrix: Data to search in

  • index: Column where the to find the data

  • firstItem: First item to match

  • secondItem: Second item to match

Expected Output

  • String: The string matched with the specified criteria

Text example

v2lookup(A1:D8, 5, "value 1", "value 2")
// Will return "correct one", the value next to "value 1" & "value 2"

Use cases

  • Look up a value that is related to two elements in Sheets

Last updated