Thread: how do i replace #n/a in a vlookup?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
infinite1013 infinite1013 is offline
external usenet poster
  
Posts: 13
Default how do i replace #n/a in a vlookup?
Can you please show me how to replace the #N/A result with 0?
=VLOOKUP(L2,'March Chargebacks'!A$1:F$613,6,FALSE)
Reply With QuoteReply With Quote