No, INDEX/MATCH can do this fairly easily. 2 ways...
NON-ARRAY...
=INDEX($C$6:$C$9,MATCH($A$3&$B$3,INDEX($A$6:$A$9&$B$6:$B$9,0)))
ARRAY method...
=INDEX($C$6:$C$9,MATCH($A$3&$B$3,$A$6:$A$9&$B$6:$B$9))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Correct, you MUST enter array formulas using CTRL SHIFT ENTERWhen you go into Edit Mode I believe you lose the curly brackets as the formula was entered as an array formula with CSE. Hence why you see the Value error.
Bookmarks