Thread: how to convert #na to 0 when using vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Diane Diane is offline
external usenet poster
  
Posts: 96
Default how to convert #na to 0 when using vlookup
When I use Vlookup, #NA returned if the vulue is not found. I need help to
convert #NA to zero or blank. Please help and thanks!
Reply With QuoteReply With Quote