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)
Bookmarks