Match two category

Enter with Ctrl + Shift + Enter and drag it down

=IF(ISNUMBER(MATCH(C14&D14,$C$5:$C$9&$D$5:$D$9,0)),"Yes","No")

in f14 dragged down
=IF(ISNUMBER(MATCH(C14&D14,INDEX($C$5:$C$9&$D$5:$D$9,0),0)),"yes","no")
no Ctrl + Shift + Enter needed

Hi my proposition in attachment (array formula)

what is the point of an array formula when there is a perfectly good non array one?

Maybe someone start to learn a array solutions from this example? (a few months before I did not know that such solution exist). Beside I did not meet yet person how knows everything and every solutions.

I'd welcome your test results, martin, but doubt that a formula that adds a function just to avoid confirming with CSE is faster than than the formula without it.

nothing to do with that,better people than me have advised against unnecessary arrays, nothing to do with speed just the point that they are not obvious and people come along later and cant fathom them out.
from ms office help

by
By Colin Wilcox
and John Walkenbach

Disadvantages of using array formulas

Array formulas can work what seems like magic, but they also have some disadvantages:

You may forget to use CTRL+SHIFT+ENTER. Remember to press those keys whenever you enter or edit an array formula.
Other users may not understand your formulas. Array formulas are relatively undocumented, so if other people need to modify your workbooks, you should either avoid array formulas or make sure they understand how to change them.
Depending on the speed of your system, large array formulas can slow down calculations.

It seems to me they are less likely to understand the rationale for the index function that appears to be doing nothing.

well we must disagree then

The real question is "How are we going to determine who is correct?" since we all know that both Texans and Brits are never wrong. (Sorry for the temporary derailment/hijacking. I'll ban myself shortly.)