View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gotroots Gotroots is offline
external usenet poster
 
Posts: 114
Default Return nothing if criteria is not met

I want to avoid "No Match Found" to return if there is no value in "C"

=IF(ISNA(MATCH(C362,'Uses and Features A'!$B:$B,0)),IF(ISNA(MATCH(C362,'RHS
additions'!B:B,0)),"No Match Found",C362),C362)

Thank you if you can help with this.