Thread: Using VLookup and format the #N/A result
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rvtrails rvtrails is offline
external usenet poster
  
Posts: 4
Default Using VLookup and format the #N/A result
I would like to format an #N/A result to a blank cell or with a 0 when
instead of the #N/A.

Can anyone assist in how to accomplish that?
Thanks!
Linda
Reply With QuoteReply With Quote