The cleanest way:
use a column ( say col V) you do not need and enter the VLOOKUP and let the NA happen
Then in your answer column enter=if(isna(V1),"",V1)

Hide col V if needed