Scotster
Board Regular
- Joined
- May 29, 2017
- Messages
- 59
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
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:
Joined together I don't get 13 as the result (I tried a few variations):
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.
individually they work fine:
Code:
=MATCH(TRUE,('DOC Table'!$A$3:$AK$3=$C22),0) = 13
Code:
=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):
Code:
=MATCH(1,('DOC Table'!$A$3:$AK$3=$B22)*('DOC Table'!$A$1:$AK$1=$C22),0) = "N/A"
Code:
=MATCH(True,('DOC Table'!$A$3:$AK$3=$B22)*('DOC Table'!$A$1:$AK$1=$C22),0)= "N/A"
Code:
=MATCH(1,('DOC Table'!$A$1:$AK$3=$B22)*('DOC Table'!$A$1:$AK$3=$C22),0)= "N/A"
Code:
=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.