Thread: If iserror help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Help in nottingham Help in nottingham is offline
external usenet poster
  
Posts: 1
Default If iserror help
Hi can someone tell my why this does not work please, have used this combo
many times in the past

=IF(ISERROR(VLOOKUP(A2,A:B,2),0,((VLOOKUP(A2,A:B,2 ))

Sample data below
Reply With QuoteReply With Quote