VLOOKUP

  • Thread starter Thread starter Dave B
  • Start date Start date
D

Dave B

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,FALSE) 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,TRUE) to
match the first six letters exactly, but that didn't work either. Any
ideas?
 
See one guess at your other post.

Dave said:
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,FALSE) 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,TRUE) to
match the first six letters exactly, but that didn't work either. Any
ideas?
Click to expand...
 
Back
Top