Compare arrays
mavxob,
Assuming you will only have one match, with the 'lookup column' in J1:J3
=SUMPRODUCT((J1=A1:F1)*(J2=A2:F2)*(J3=A3:F3)*COLUM N(A1:F1))
HTH,
Bernie
MS Excel MVP
"mavxob" wrote in message
...
Hello,
I need to compare a column with a set of columns and get the column number
that match the lookup column. Can somebody help? thanks!
lookup column:
1
2
3
A B C D E F
2 4 5 6 1 5
5 2 3 2 2 4
1 2 5 1 3 6
expected result is 5 (col E)
|