Match with Multiple criteria in the same column

[Scotster]

I'm pretty sure I've done this before but I can't for the life of me figure out why this won't work. I'm looking to match the column number where row 1 and row 3 match certain values.

individually they work fine:

=MATCH(TRUE,('DOC Table'!$A$3:$AK$3=$C22),0) = 13

=MATCH(TRUE,('DOC Table'!$A$1:$AK$1=$B22),0) = 13

Joined together I don't get 13 as the result (I tried a few variations):

=MATCH(1,('DOC Table'!$A$3:$AK$3=$B22)*('DOC Table'!$A$1:$AK$1=$C22),0) = "N/A"

=MATCH(True,('DOC Table'!$A$3:$AK$3=$B22)*('DOC Table'!$A$1:$AK$1=$C22),0)= "N/A"

=MATCH(1,('DOC Table'!$A$1:$AK$3=$B22)*('DOC Table'!$A$1:$AK$3=$C22),0)= "N/A"

=MATCH(True,('DOC Table'!$A$1:$AK$3=$B22)*('DOC Table'!$A$1:$AK$3=$C22),0)= "N/A"

Can someone point me in the right direction. If I need to upload a specific example I can, I just thought it would be obvious what I was doing wrong.

 

[Scotster]

Update.

Solved the problem. I'm not sure why this has happened, but:

=MATCH(TRUE,('DOC Table'!$A$3:$AK$3=$C22),0) = 13

For whatever reason the above on it's own returns the correct column. But the actual query is based on a decimal value. So, for the multiple criteria I had to use the following:

=MATCH(1,('DOC Table'!$A$3:$AK$3=$B22)*('DOC Table'!$A$1:$AK$1=VALUE($C22)),0)