Excel match #value 1

[GPnew]

Sample Da

http://www.tek-tips.com/threadminder.cfm?pid=68ta

a 55 56 57 55 56
b 12 12 12 13 13

Trying to return the column number where row a = 56 stored in F5 and row b = 12 (F6)
The answer should b 3
This is what I have tried
=MATCH(1,$F$5=$A$1:$F$1*$F$6=$A$2:$F$2,0) Result #value
=MATCH($F$5&$F$6,$A$1:$F$1&$A$2:$F$2,0) Result #value

I tried this to test the logic
=MATCH($F$6,$A$2:$F$2,0) result 2

Any Ideas

Thanks

 

[SkipVought]

Hi,

=SUMPRODUCT((a2:f2=f5)*(a3:f3=f6)*(column(a2:f2)))

 

[SkipVought]

BTW, the MATCH() function only returns the FIRST match offset number. It is a poor tool for your stated purpose.

 

[SkipVought]

BTW2, if f6 contains 13, then you should get 6.