Using Find with a Table

[DC]

I have two colums I need to compare. I want to know if the data in the first column is in the second. I cant use the Match or Vlookup because most of them are not exact matches. Usually the first column has only part of the data that the second does.

I just need to know if there is a match anyhere in the second column.

 

[EdE]

If all you want to know is if data in column A is in Column B, enter this formula in column c:
=IF(ISNA(MATCH(a1,b1:b25,0)),"Not Found","Found")
Where a is the data to be found and b1:b25 is the data range to look in. 0 means an exact match.

HTH!

 

[DC]

Thanks