View Single Post
  #1   Report Post  
Kevin
 
Posts: n/a
Default VLookup Return Value

I am trying to use VLookup to retrieve a value from a table I have already
established. The lookup will always return a value. This is expected. If it
does not find an appropriate value I don't want it to return anything.
Currently the lookup is returning #N/A if it finds nothing. I would prefer
that it not display anything. How can I do this?

Thanks in advance!