INDEX Match

[gdallas]

I’ve been at this for ages, answers probably staing me in the face, but I just cant work this out!

L26 returns incorrect information. Input parameters are F29 and F30. In its current state, it returns the value “b”, where I think it should be returning “1”, i.e the intersection point for “3Ph” & “Single-core 70°C thermoplastic non-arm Cu Table 4D1”

What am I doing wrong?

Many thanks.

[zbor]

You need to reverse rows and column matching:

=INDEX(cablemakeup1,MATCH(F30,'Design Data'!C83:C94,0),MATCH(F29,'Design Data'!C83:F83,0))

[NBVC]

You have the Row and Column arguments reversed within the Index function:

Try:

=INDEX(cablemakeup1,MATCH(F30,'Design Data'!C83:C94,0),MATCH(F29,'Design Data'!C83:F83,0))

[NBVC]

You have the Row and Column arguments reversed within the Index function:

Try:

=INDEX(cablemakeup1,MATCH(F30,'Design Data'!C83:C94,0),MATCH(F29,'Design Data'!C83:F83,0))

[JeanRage]

Hi,

A tiny inversion row , column

=INDEX(cablemakeup1,MATCH(F30,'Design Data'!C83:C94,0),MATCH(F29,'Design Data'!C83:F83,0))

HTH

[gdallas]

Ah, thanks guys. I'll Spread the love to Zbor this time since he was first in there! :-)

[zbor]

Now if you wonder WHY is that press ctrl+F3 and you'll see that in your Name Manager cablemakeup1 first have your F29 match and then your F30.