View Single Post
  #1   Report Post  
LEsa
 
Posts: n/a
Default How to match two different cells text, if the text is not in the .

Column A has Bob Fred Tom
Column B has Tom Bob Fred

I would like to match and identify someway

Column A has Bobby Fred Tom
Column B has Fred Tom Bob
That is not a match

I use vlookup to get exact matches. How to get matches if word order is
different?