View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Donna[_2_] Donna[_2_] is offline
external usenet poster
 
Posts: 76
Default Matching function or no match


I am using this formula to compare 2 list to see which numbers are not
included in both column A and Col C. The formula I am using below pulls out
the ones that i do have a match . Is there another function that I could
use that would only pull out the ones that there is not a match?

=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)
Thanks