Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP
First, .worksheet.functions is thriving. (But I don't use OE as a newsreader.
I'm not sure what you should reset.) Maybe just unsubscribing and resubscribing would be sufficient. (Just a guess). but your formula could be changed to: =VLOOKUP(LEFT(b37,6),LEFT(Schooldistricts,6),1,FAL SE) (hit ctrl-shift-enter instead of enter. This is an array formula and if you do it correctly, excel will wrap your formula with curly brackets {}.) Did you really mean to return the first column? Maybe 2 or 3??? Dave B wrote: 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... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |