vlookup value not found

plz help when i use this

=VLOOKUP(value($B7),Auto!$A$2:$G,3,FALSE)

when the value is not found / not there it returns the error #N/A in the cell and says Error did not find value in vlooup evaluation

this is because the value is not there, what i want to know is if it comes back as #N/A in the cell how can i get it to leave the cell Blank not saying #N/A

thanks

Hi
I don't know which version of excel you're using & I've never heard of google excel but one of these will work

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Cheers