View Single Post
  #1  
Old October 13th, 2003, 03:34 PM
Jeff Armstrong
external usenet poster
 
Posts: n/a
Default VLOOKUP Question

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