Compare one list with another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a function, formula, etc. that will let me know if there are any items in list A that also appear on list B. I have used a 'Compare Cell Contents' formula (=OR(EXACT(B2, A2:A4)) in the past; but, this current task is a little different. The matching items may not look exactly the same. For example, in list A, an item may appear as 'acetone', but, in list B, the item may appear as 'Acetone, 98%'. I've looked into the SEARCH and FIND functions, yet, unlike the EXACT function, you cannot search an entire range. You can only search a single cell. Each list as over 1,000 entries, so that is not useful. Any suggestions?
 
Hi
try a formula like
=IF(COUNTIF($A$2:$A$1000,"*" & B2 & "*")>0,"Match","no match")
 
Back
Top