View Single Post
  #2   Report Post  
 
Posts: n/a
Default

I usually use something like this:

=if(ISNA(vlookup(A,B,C),0,vlookup(A,B,C))

Where A,B,C are the arguments of the vlookup. I usually use "" (open
quote, close quote) in place of the 0, to give me a blank response.