Hi everyone,
Currently am using an array index + match formula to return a value based on 2 criteria:
{=IFERROR(INDEX(Sheet1!$F$2:$J$1572,MATCH(1,(Sheet1!$F$2:$F$1572=$D1485)*(Sheet1!$G$2:$G$1572=L$1),0),5)*$F1485," ")}
This seems to have worked for me so far. Column F in sheet 1 is the...