Hi, I'm new to the forum - great posts and knowledge shown here - it's humbling!

I'm converting a database with about 8000 entries using excel to edit, merge, and alter some large tables before I import it.

My current challenge is this:

I have 2 tables on Sheet 1 and Sheet 2:

Sheet one is 700 names like the 2 rows shown in the image
xlimg1.gif

Sheet two has 5000 entries, but only one column of arranger names (not split into first/last)

xlimg2.gif

I am trying to get Sheet 2 to return the Arr ID number if it finds a match in Sheet 1.

The formula below (in column A of Sheet2) works only if the name in Column B Sheet 2 is the last name only - which it never is) (actually, if the last name is the left most in the cell, more letters can be to the right of it and it still works). I thought the wildcards would take care of that - what am I missing?

=INDEX(Sheet1!A2:C3,MATCH("*"&B2&"*",Sheet1!B2:B3,0),1)

Help! (Thanks in advance - also, I probably have been unclear, I'll be happy to be more clear - but this kind of posting is foreign to me - I'm a musician)