Find a not exact match using vlookup
 

I am trying to pull data together from 2 outside sources. I want to match
names from the two sheets. However, one sheet has all names (about 13,000 of
them) with a middle initial and one doesn't. So, I cannot use an exact match.
But when I use TRUE I am getting the wrong data. Any ideas??

Thank you for you help!!

Russ

Nevermind....It's as easy as just splitting cells.

"Russ B" wrote:

I am trying to pull data together from 2 outside sources. I want to match
names from the two sheets. However, one sheet has all names (about 13,000 of
them) with a middle initial and one doesn't. So, I cannot use an exact match.
But when I use TRUE I am getting the wrong data. Any ideas??

Thank you for you help!!

Russ