v2lookup
Vertical lookup using two elements to find an output
- matrix: Data to search in
- index: Column where the to find the data
- firstItem: First item to match
- secondItem: Second item to match
- String: The string matched with the specified criteria
v2lookup(A1:D8, 5, "value 1", "value 2")
// Will return "correct one", the value next to "value 1" & "value 2"
- Look up a value that is related to two elements in Sheets
Last modified 7mo ago