Thread: Replace #N/A
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
damorrison
 
Posts: n/a
Default Replace #N/A
=IF(ISNA(VLOOKUP(G8,D3:E6,2,FALSE)),0,VLOOKUP(G8,D 3:E6,2,FALSE))

Reply With QuoteReply With Quote