What am I doing wrong with this index match formula with multiple criteria

I'm hoping to create a formula in the highlighted yellow cells in Sheet A that will pull in the result from Sheet B, if it matches two particular criteria.

I've attached an example sheet.

I'm hoping that the formula in B2 in Sheet A, can populate with the correct data in Sheet B if the project id and question id match.

=INDEX('Sheet B'!B2:B7,MATCH(C2&A2,INDEX('Sheet B'!$A$2:$A$7&'Sheet B'!$D$2:$D$7,0))) is giving me an error of #n/a or 0, and can't figure out why

Thanks in advance for the help!

Try this:

=INDEX('Sheet B'!$B$2:$B$7,MATCH(1,('Sheet B'!$A$2:$A$7=A2)*('Sheet B'!$D$2:$D$7=C2),0))

Ali, in Excel 2019 will the OP need to array enter this formula?

Possibly!

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).