REPLACE "0" WITH A DIFFERENT VALUE

[meppwc]

The formula below works as it should.
LET(m,MATCH(T4,ORACLE!$A$1:$A$14998,0),IF(ISNA(m),"CSN Not in OBIEE",IF(INDEX(ORACLE!$BH$1:$BH$14998,m)="","T&M",INDEX(ORACLE!$BN$1:$BN$14998,m))))
I want to make a change to the very last section of the formula (INDEX(ORACLE!$BN$1:$BN$14998,m)))))
Currently if the BN cell is blank, the equation returns "0".
I would like it to return "NOT ON SERVICE CONTRACT"

I have tried numerous times to add the change but continue to fail with the syntax
Any assistance would be greatly appreciated.

 

[Fluff]

How about

=LET(m,XMATCH(T4,ORACLE!$A$1:$A$14998),x,INDEX(ORACLE!$BN$1:$BN$14998,m),IF(ISNA(m),"CSN Not in OBIEE",IF(INDEX(ORACLE!$BH$1:$BH$14998,m)="","T&M",IF(x="","NOT ON SERVICE CONTRACT",x))))

 

[meppwc]

Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.