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!

This will probably work for you, but the names on page A must be exactly the same as the names on page B. ie. John J. Smith=Smith, John J. or Mary T. Brown=Brown, Mary T. etc. First I made a named range Employee on Page A and placed this formula on Page B-Cell B2-Copied down.

=VLOOKUP(RIGHT(A2,LEN(A2)-FIND(",",A2)-1)&" "&LEFT(A2,FIND(",",A2)-1),Employee,2,0)

It works for me. Hopefully it will work for you. Any questions come back. I have attached an updated copy of your sheet below.

See ya,

Dean

Thank you so much for your reponse. Unfortunately, I need to find out a way to search for the Keywork (last name) because they dont match perfectly. The Middle initial is only included on 1 list.

I dont even know if this is possible but thought maybe someone would know.

Thanks again. I appreciate your help.