VLookup returning zero

[Alphazulu]

Good afternoon -

I have a vLookup returning a 0 from a table that contains blanks. I'd like to return a blank if a blank is found instead of the 0.

Here is the current formula I'm using

=IF(ISNA(VLOOKUP(E3,Sheet2!$A$2:D51,4,FALSE)),"",VLOOKUP(E3,Sheet2!$A$2:D51,4,FALSE))

Thanks in advance for any help you may have

 

[barry houdini]

One way would be like this

=IF(ISNA(VLOOKUP(E3,Sheet2!$A$2:D51,4,FALSE)),"",IF(VLOOKUP(E3,Sheet2!$A$2:D51,4,FALSE)="","",VLOOKUP(E3,Sheet2!$A$2:D51,4,FALSE)))

 

[Alphazulu]

That worked!

Thanks