How about putting your VLOOKUP within this

=IF(VLOOKUP()=1,VLOOKUP(),NA())

Or replace NA() with "". Just replace VLOOKUP() with your VLOOKUP formula.

"Areid" wrote:

I want to do a vloopkup and if is not 1 make it appear blank?