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.
I just need to know if there is a match anyhere in the second column.