View Single Post
  #3  
Old October 13th, 2003, 06:57 PM
Felipe
external usenet poster
 
Posts: n/a
Default VLOOKUP Question

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

-----Original 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
.