Index Match formula help for Google Sheets

[jimbogarner]

Hi,

This will be a really easy answer for 99% of people on this forum but I can't get my head around the Index/Match formulas, I have one which i've copied from another workbook but I can't replicate it;

The below is sheet2 that the above is referencing;

Any help is much appreciated (and also a brief explanation as to what I'm doing wrong would be great too please for future reference!)

Thanks,

James

 

[Fluff]

Try it like

=ArrayFormula((-INDEX(Sheet2!$H$6:$S$168,MATCH(1,(Sheet2!$E$6:$E$168=$A13)*(Sheet2!$F$6:$F$168=$B13)*(Sheet2!$G$6:$G$168=$C13),0),MATCH(D$10,Sheet2!$H$5:$S$5,0)))/D$11)

 

[jimbogarner]

perfect that worked thanks very much

 

[Fluff]

You're welcome & thanks for the feedback.