IFERROR, VLOOKUP and another IF statement HELP!!

[Dimsum06]

Is there a way to add another criteria to this current formula? I want to add if this range/column has a certain word, in my case OUTSTANDING, to return BLANK"".
Current Formula: IFERROR(VLOOKUP(B9,'REPORT!A:C,3,FALSE),"")

Thank you!!!

 

[Dimsum06]

Does just doing the lookup once like this also work?

=SUBSTITUTE(IFNA(VLOOKUP(B9,REPORT!A:C,3,0),""),"OUTSTANDING","")

If not, try

=SUBSTITUTE(IFERROR(VLOOKUP(B9,REPORT!A:C,3,0),""),"OUTSTANDING","")

The first formula you provided actually works!! I typed in outstanding instead of Outstanding so it still would return the word. I honestly did not know that this was case sensitive! Thank you so much. I will try the 2nd formula too.

 

[Dimsum06]

That is not happening with the sample above and I cannot see how it is possible since the formula contains SUBSTITUTE(...,"OUTSTANDING","") ...
... unless your "OUTSTANDING" is not all upper case like is written in each case above?

=LET(v,IFERROR(VLOOKUP(B9,REPORT!A:C,3,0),""),IF(v="OUTSTANDING","",v))

Thank you so much, never knew it's case sensitive

 

[Peter_SSs]

I will try the 2nd formula too.

The second formula is only relevant if there are actual error value in column C of the 'REPORT' sheet. If the error check is simply to cover the case where the value being looked up does not exist in column A of 'REPORT' then the first formula should be sufficient.

Also, just confirming that the formula in post 10 and @pjoaquin's formula are not case-sensitive. That issue only arose because of the use of SUBSTITUTE in my first two formulas.

Anyway, you can use whichever formula you want but thanks for following through to resolve the apparent issue with my formulas. It is always good to know why certain things are happening.