Leaving cells blank if return value is met using vlookup

[GMan-62]

I'm using the below formula to find the result and post my data, but if the 3rd cell to the right of A245 is blank it returns a 0 for the result. Is there a way to have it leave the result blank if the 3rd cell is blank vs. returning a 0?

=IF(ISNA(VLOOKUP(A245,A245:C265,3,FALSE)),"",VLOOKUP(A245,A245:C265,3,FALSE))​

 

[Jonmo1]

Did you try my suggestion here?
http://www.mrexcel.com/forum/showth...urn-blank-(empty-)-cell&p=3192213#post3192213

 

[VoG]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).