Finding Duplicates across Sheets without Exact Values

This didn't do it. I have identified someone who is on both lists, we will call her Dr. Lilly White.

On the Symphony sheet she is listed in one column as "Dr. Lilly White".

On the Library sheet she is listed in three columns: Greeting (Dr.), First Name (Lilly), and Last Name (White).

When I search the Symphony sheet's one column against the last name column it didn't give me anything by Dr. White's name.

I'd also like to add that I tried breaking text to columns but the columns are all spread out because some names have more things than others ("Dr. Lilly White" is broken into 3 columns vs. "Dr. and Mr. Lilly White" which is broken across 5). It's just a mess.