Index/Match to search multiple columns

I have a workbook with two worksheets in the attached - one is called "With ID", the other is "Without ID."

I need to pull in column A id's from worksheet 1 into column A on worksheet 2 by searching for last name then first name. The names in worksheet 1 are in different formats and sometimes have up to 30 names in one cell in columns c and d.

However, in worksheet 2, (without id), each name is in its cell.

I was trying Index/Match feature but can't get it to work. Can somebody look at the attached and tell me how to do it.

It would be greatly appreciated.

A~

Thank you - everything is almost working. For some reason though, for only one gang in particular, it is only matching half of the names in the cell. This gang can have up to 30 names in one cell. Why is it only matching half the names? Any ideas?

Column C (With ID) Column A (Without ID) Column B (Without ID)
washington, george TTTX0001 WASHINGTON, GEORGE
nickels, joe NICKELS, JOE
strait, george t TTTX0001 STRAIT, GEORGE
Wilkes, mike WILKES, MIKE
wilkes, bob WILKES, BOB
gomez, miguel javier GOMEZ, MIGUEL
smith, samual TTTX0001 SMITH, SAMUAL


Any insight would be appreciated.

Thank you.
A~

The attachment is below. I would like all of the Gang ID's in'Without ID - column A' filled in by matching the names in column b to one of the names in the 'with id' columns c,d or e.