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...