Excel - Return value based in two conditions

Question

I need to get the cross values beetween 2 columns:

i only can with auxiliary column, is possible to get in one cell formula?

Thks in advance

Answer 1

The INDEX-function is just about tailor-made for this. Your horizontal array seem to be an index already, and if that holds for the actual data you can simply use this one.

However if the horizontal array is not a sequence of 1, 2, 3 and so then use MATCH for both arrays, like this:

I didn't use "$" in the example for better readability, but you want to apply that for the formula to function to work when you copy it downwards.