Feb 19 2021 12:12 PM
Feb 19 2021 12:54 PM
SolutionIn E9:
=IFERROR(INDEX(INDIRECT($P$14),MATCH(Sheet1!B9,INDIRECT($Q$14),0),MATCH(Sheet1!$C$6&Sheet1!$C$7&Sheet1!$C$8-1,INDIRECT($R$14),0)),"-")
Fill down to E17
Feb 20 2021 07:26 AM
If you are on Excel with dynamic arrays, that could be
=IFERROR(INDEX(INDIRECT($P$14),MATCH(B$9:B$17,INDIRECT($Q$14),0),MATCH($C$6&$C$7&$E$8:$F$8,INDIRECT($R$14),0)),"-")
Feb 19 2021 12:54 PM
SolutionIn E9:
=IFERROR(INDEX(INDIRECT($P$14),MATCH(Sheet1!B9,INDIRECT($Q$14),0),MATCH(Sheet1!$C$6&Sheet1!$C$7&Sheet1!$C$8-1,INDIRECT($R$14),0)),"-")
Fill down to E17