Index / Match Formula

[KishorKK]

Hi Friends,


Please help to solve this, i want to use here index/ match formula but i am unable to get values in these cells. Please help me i am attaching excel sheet. Thanks

 

[Chihiro]

Something like below.
=INDEX($B$2:$E$6,MATCH($A13,$A$2:$A$6,0),MATCH(B$12,$B$1:$E$1,0))

Copy down and across.

 

[SirJB7]

Hi, KishorKK!
Please write down the formulas are you using and what issues have you run into.
Regards!

 

[Monty]

Hello Kishore!

Check attached file solution provided by Chihiro works fine!

 

[KishorKK]

HI Chihiro,

it's working can you please explain me about this formula means how you taken it

 

[pecoflyer]

Have you tried the " Evaluate formula" tool to see what this formula does?

 

[Chihiro]

Have a read of following:
http://www.mbaexcel.com/excel/how-to-use-index-match-match/

Alternative to Index/Match/Match
http://chandoo.org/wp/2010/11/09/2way-lookup-formulas/