Index Match by matching two rows

[msharma864512]

I am trying to pull data through index match by matching two rows and one column

The details are in the attached file.

 

[bosco_yip]

Try.......

In C7, copied across and down :

=IF($B7="","",IFERROR(INDEX(Sheet1!$B$3:$S$269,MATCH($B7,Sheet1!$A$3:$A$269,0),MATCH(1,INDEX((Sheet1!$B$1:$S$1=$B$5)*(Sheet1!$B$2:$S$2=C$6),0),0)),""))

Regards
Bosco

 

[msharma864512]

This is perfect Bosco, Thank u very much for all your help