Copy Data From Book1 to Book2 if Columns A & B fuzzy-match.

[OlderMan]

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 CAC.

CAC has 3 columns of data, C"Approver", D"Designer" , E"CAT No." that I want to copy into CA columns C D E with the same name.

CAC has a table so it can be sorted by any column. A row in CAC can only be used once.
I tried using VLOOKUP and then formula in CA C2
=IF(COUNTIF(A2:B500,B2)+COUNTIF(CAC!A2:B500,B2),CAC!C2,0)
This was closest I got to it working. But if I use the table in CAC to sort a column it all gets messed up.

If this isn't clear I can show it by creating two tables.

Thanks, Bob