Vlookup - empty cell if '0' is found

Hi guys, pretty much what the title says..
I'm using this formula.. in G27 is numbers that is retrieved by another formula.. but sometimes '0' will appear.. which gives me #N/A because there is nothing linked to that number. anyway to change the formula just to be blank if '0' is in G27?
Thanks

Please Login or Register  to view this content.

Try


=IF(OR(G27="",G27=0),"",VLOOKUP(G27,Information!$B$4:$F$371,4,FALSE))

try this:

=iferror(VLOOKUP(G27,Information!$B$4:$F$371,4,FALSE),"")

Worked, thanks john!