Match a unique column to two separate columns

0
votes

I have one column in google sheet with unique values. I then want to match this column to two separate columns. See google sheet below for an example. I want the output in column "B".

[https://docs.google.com/spreadsheets/d/10AOYlqsScoDUfcOaJd2opjjC_8zXSOP3_HBTOCCrb6U/edit#gid=0][1]

2
arraysgoogle-sheetsmaxgoogle-sheets-formulagoogle-sheets-query

2 Answers

1
votes

You can use maxifs:

=maxifs($F$4:$H$14,$E$4:$G$14,A4)

enter image description here

A longer approach could be the following:

=max(vlookup(A4,$E$4:$F$14,2,false),vlookup(A4,$G$4:$H$14,2,false))
0
votes

try:

=QUERY(FLATTEN(F4:F14, H4:H14), "where Col1 is not null")

0