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)