CODEWITHSUNDEEP
arraysgoogle-sheetsmaxgoogle-sheets-formulagoogle-sheets-query
filipfilip1234
filipfilip1234

Reputation: 3

Match a unique column to two separate columns

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]

Upvotes: 0

Views: 39

Answers (2)

player0
player0

Reputation: 1

try:

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

0

Upvotes: 0

BigBen
BigBen

Reputation: 49998

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))

Upvotes: 1

Related Questions