Excel IF is returning a #N/A

My statement is returning #N/A instead of the if false value. Works fine for the true value.

Ive simplified it down to this;

=IF(MATCH(B5,’Size Ref’!A4:A9,0),”oops”,”helpme”)

But ultimately the equation will be;

=IF(MATCH(B4,’Size Ref’!$A$4:$A$9,0),(((INDEX(‘Size Ref’!$B$4:$B$9, MATCH(B4,’Size Ref’!$A$4:$A$9, 0), 1))*D4) + ((INDEX(‘Size Ref’!$F$4:$F$9, MATCH(C4,’Size Ref’!$E$4:$E$9, 0), 1))*D4)), “—“)

or whatever it is that I am doing wrong here. enter image description here