I'm trying (really hard), to create a formula that indexes an area then carries out multiple matches in order to return a value onto a cell on another sheet.
I've got as far as: =IFERROR(INDEX(Sheet1!E5:BM20,MATCH(Sheet2!C5,Sheet1!C5:C20,0),MATCH(Sheet2!D4,Sheet1!D5:D20,0),MATCH(Sheet2!C3,Sheet1!E3:BM3,0)),0) but it's just not working.
I've attached a sample sheet to show what it is I'm try desperately to do but right now I'm losing the will to live. Any help would be so very much appreciated please??
Kind regards and thank you.....