vlookup with keywords?

I have 2 sheets - I need to reference one to get detail on the second sheet that is on the first sheet. I was initially going to do a Vlookup with the names ( each sheet has names of people) but unfortunately it isnt that easy.
The first sheet has names on it such as, "Doe, John H."
The other list will have it listed as "John Doe"

Is there an easy way to do a find for the first word in this file ( the last name) and grab the cell with that in the 2nd list?

I hope this makes sense. I attached an example in case it didnt.
Thanks so much for any help at all!