vlookup/index-match w/ multiple lookup values

Hi all -

This is a gross simplification of a more complex issue, but I think if I can figure this part out, the rest should fall in line. (And I've spent WAY too much time trying to work it out myself and have stretched my minute knowledge to the limit )

Here's a simplified table:

First	Last	Data	Last,First	Data
John	Smith		Smith, David	###
xxx	xxx		Smith, John	###
xxx	xxx		Jones, John	###

The basic gist is that I'd like to use either VLOOKUP or INDEX-MATCH to find both the First AND Last name text strings (e.g., "John" AND "Smith") within the same cell of the Last,First column (e.g., "Smith, John") and return the adjacent value into the corresponding empty cell. With the commas and spaces, I know I need to search for partial matches, incorporate wildcards, etc., but I haven't been able to put it all together.

Any help would be greatly appreciated.

Thanks -

Thank you, mrice and FDibbins.

Both
=INDEX($E$2:$E$4,MATCH(B2&", "&A2,$D$2:$D$4,0))
and
=VLOOKUP(B2&", "&A2,$D$2:$E$4,2,0)
worked.

Now, a quick follow-up to make things a tiny bit more complicated.

Using the same table, say there were other text and numbers along with the name in the First,Last cells (e.g., "ABC Smith, John 2015").
How could I then incorporate a search for the First,Last cell that contains both "John" AND "Smith" (so, two required partial strings and not an exact match) using VLOOKUP or INDEX-MATCH?

I hope that's not too muddled.

Got it. Awesome. Thank you so much.

And if there was text between the two partials I'd just put a wildcard in between them:
=INDEX($E$2:$E$4,MATCH("*"&B2&"*"&A2&"*",$D$2:$D$4,0))
=VLOOKUP("*"&B2&"*"&A2&"*",$D$2:$E$4,2,0)

Finally (and thank you for humoring me), what if I don't know which order they will appear in the Last,First cell (e.g., "abc John Smith 2015" or "2015 Smith, John abc")?

Thank you very much.

For my purposes, I replaced ", " with "*", and it's working fine.

I guess with all of this, I was conceptualizing the searching for multiple partial strings a bit differently with a bunch of half-learned coding languages floating around in my brain.

Much obliged.