Match Index

[Ian1976]

Hi could anyone help me with this i'm going number blind!

https://1drv.ms/x/s!Aszg_mMOoSFEgSM203OyZbldchOt?e=LLq6Ur

When I select TU1 in C7 I get the correct results from the table $J$14:$O$20, but when I select TU2 from the dropdown in C7 I'm not getting the results I need?

Can someone point me in the right direction please?

Thanks

 

[steve the fish]

Re: Match Index help needed please.

Looks fine to me.

 

[steve the fish]

Re: Match Index help needed please.

Think maybe i see it now. Maybe this:

=INDEX($J$14:$O$20,MATCH($K$5,$J$14:$J$20,0),MATCH(INDEX($F$7:$H$9,MATCH(K5,$D$7:$D$9,0),COUNTA($K$5:K5)),$J$13:$O$13,0))

 

[Ian1976]

Re: Match Index help needed please.

Thanks that works a treat, what do I need to alter for M8,N8,O8 & P8?

Thanks

 

[steve the fish]

Re: Match Index help needed please.

In K7:

=INDEX($J$14:$O$20,MATCH($K$5,$J$14:$J$19,0),MATCH(INDEX($F$7:$H$9,MATCH(K5,$D$7:$D$9,0),COUNTA($K$5:K5)),$J$13:$O$13,0))

In L7:

=INDEX($J$14:$O$20,MATCH($K$5,$J$14:$J$19,0)+1,MATCH(INDEX($F$7:$H$9,MATCH(K5,$D$7:$D$9,0),COUNTA($K$5:L5)),$J$13:$O$13,0))

Then copy the two cells and paste into M7 and 07.

 

[Ian1976]

Re: Match Index help needed please.

Thanks you so much! Works great!