I have two books, Book1(CA) and Book2(CAC).
Columns A and B of each book have the same data but not necessarily on the same row.
Column A = "Trial Date" Column B = "Hosting Club" in each book.
"Hosting Club" name in CA may not be spelled exactly the same or use upper case characters like in...