Matching

[MrSales]

I have three columns and I want to find a match in either column a,b,or c and have it return either one of the two colums left out of a,b or c. How do I attempt that?

Thank you,

[daddylonglegs]

So if there's a match with B do you want to return A or C, or doesn't it matter?

This formula searches for E2 in A2:C2 and returns the cell to the left, unless the match is C2 in which case it returns A2

=INDEX(A2:C2,MOD(MATCH(E2,A2:C2,0),3)+1)