I am having a difficult time with a lookup that shows a partial match of character. I tried adding wild cards =VLOOKUP("*"&A1&"*",Sheet2!A:B,2,FALSE) on both sides, however, it does not seem to identify partial matches. A normal vlookup does not work as the data is not exact. I am basically trying to pull the day from table to and match it to the slightly different name from table 1. Example. BURTON, JAMES (1288) and Friday, MYERS, DERICK (0101) and Monday.

Can you please help?

table 1

BURTON, JAMES (1288)
MYERS, DERICK (0101)
EBERHARD, RON (9330)
MEADOWS, BEN (3958)
MORGAN III, DANIEL (5535)
RIVERA, JOE (6793)
DEHAVEN, JOSH (1761)

table 2

BURTON, JAMES ------- Friday
MYERS ------- Monday
EBERHARD, RON ------- Tuesday
MEADOWS, BEN ------- Tuesday
MORGAN III, DANIEL ------- Tuesday
RIVERA, JOE ------- Monday
DEHAVEN, JOSH ------- Monday