I have two tables of data with names for the same entity that aren't exactly
the same in each table, so I'm trying to link them together by using IDs and
VLOOKUP. For instance, in one table I have "Beachwood City SD" and in the
other I have "Beachwood Ohio City Sch Dist". This is the same school
district, and I want to merge the data in the two tables to one master
table. But when I use VLOOKUP(B37,SchoolDistricts,1,TRUE) it doesn't give
me the correct matches:

Name1 Name2
VLOOKUP Result
Beachwood City SD BEACHWOOD OHIO CITY SCH DIST BEACHWOOD OHIO CITY SCH
DIST
Beavercreek City SD BEAVERCREEK OHIO LOC SCH DIST BEACHWOOD OHIO CITY
SCH DIST
Bedford City SD BEDFORD OHIO CITY SCH DIST BEAVERCREEK
OHIO LOC SCH DIST
Bellaire Local SD BELLAIRE OHIO CITY SCH DIST BEDFORD OHIO
CITY SCH DIST
Bellefontaine City SD BELLEFONTAINE OHIO CITY SCH DIST BELLAIRE OHIO CITY
SCH DIST

It seems like it just takes the first match with the same first two or three
letters. I even tried to use VLOOKUP(Left(B37,6),SchoolDistricts,1,FALSE)
to
match the first six letters exactly, but that didn't work either. Any
ideas?

P.S. Has the microsoft.excel.worksheet.functions newsgroup been
discontinued? My Outlook Express won't synchronize any message headers more
recent than 06/15/2002...