Quote Originally Posted by almugs View Post
Thanks very much. Works like a charm. It looks like Index Match wasn't the right way to go for this
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.

When 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.
Correct, you MUST enter array formulas using CTRL SHIFT ENTER