A | B | D | E | F | G | H | I | |
Smith | Jones | White | Jones | True | ||||
Jones | Smith | True | ||||||
Smith | Johnson | |||||||
Group1 | Group2 | Group3 | Group4 |
<tbody>
</tbody>
I am trying to lookup values A1 & B1 (Smith & Jones) to find the row in range D:E where both values occur regardless of order (can be Jones/Smith or Smith/Jones).
...and... if this matching row has a value of True in Table to right (columns F:I ), return the Group name of the column which is True.
Desired result for data above: For Smith & Jones - matches row 2 of range D:E - this row has a value of True in column G and would return the result of "Group2"
I will also need to adapt the formula for three values lookup for matches in a 3 column range.
It seems like would be pretty straightforward but my brain seems to be broken today.. any help is much appreciated!
Last edited: