Wondering if anybody a help with the following:

I am currently using the following formula to return blanks when an error results from 'E25' being blank:

=IFERROR(VLOOKUP(E25,'WORKSHEET'!$A$1:$S$1000,19,FALSE,"")

However, when E25 is not blank but row '19' in '$A$1:$S$1000' has no results, the formula returns a '0'.

In the case of there being no result to return, I'd like there also to be a blank (and for there to only not be a blank when there is a result to return - 'YES or 'NO' being the only 2 returnable options in this case).

I have tried OR and AND formulae but with no success.

I'm tired so maybe I have missed something.

Any help would be much appreciated.