VLOOKUP Question

[Jeff Armstrong]

I have a VLOOKUP function that retrieves information from
a list. There will be times that the information trying
to be retrieved won't be in the list. This generates a
#NA for the cell. My question is how can I leave this
cell blank if no data is found? Below is my formula.

=VLOOKUP(A2,$B:$X,14,FALSE)

Thanks,
Jeff

 

[Peo Sjoblom]

One way


=IF(COUNTIF($B:$B,A2),VLOOKUP(A2,$B:$X,14,FALSE),"")

 

[Felipe]

=IF(ISNA(VLOOKUP(A2,$B:$X,14,FALSE)),"",VLOOKUP
(A2,$B:$X,14,FALSE))