Add condition to VLOOKUP

[sharky12345]

I have this VLOOKUP and I want to add a condition;

=IFERROR(VLOOKUP(B3,Teams!$B$28:$C$50,2,FALSE),"")

The condition is that if the value in column C is "NEW" then I need the cell to be blank. As you can see, I have worked out how to add an error trap but don't know how to add an extra 'IF' condition, if in fact that is possible?

 

[Peter_SSs]

Try

=IFERROR(IF(VLOOKUP(B3,Teams!$B$28:$C$50,2,FALSE)="NEW","",VLOOKUP(B3,Teams!$B$28:$C$50,2,FALSE)),"")

 

[FDibbins]

Another way...
=IF(VLOOKUP(B3,Teams!$B$28:$C$50,2,FALSE)="NEW","",iferror(VLOOKUP(B3,Teams!$B$28:$C$50,2,FALSE),""))

 

[sharky12345]

Guys - thanks to both, will try both suggestions.

 

[Peter_SSs]

Another way...
=IF(VLOOKUP(B3,Teams!$B$28:$C$50,2,FALSE)="NEW","",iferror(VLOOKUP(B3,Teams!$B$28:$C$50,2,FALSE),""))

Hi Ford
I don't think that is the same. If the VLOOKUP returns something other than an error then your formula does what was asked, but if the VLOOKUP results in an error, then the OP's original formula returns "", whereas yours returns an error.