View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Unable to search for a text value with IF

I think if the word does not exist then you want to return a zero, so
you need to re-arrange your formula. Something along the lines of:

=IF(ISERROR(MATCH(Sheet2!A2,Sheet1!B1:B10)),0,SUM Formula)

Hope this helps.

Pete