One way


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



--

Regards,

Peo Sjoblom


"Jeff Armstrong" wrote in message
...
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