| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup more than one exact match | Excel Worksheet Functions | |||
| using vlookup to find exact match | Excel Discussion (Misc queries) | |||
| using vlookup - how do I match 2 spreadsheets w/o same exact numb. | Excel Worksheet Functions | |||
| Find a match that;s not exact | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Hybrid Mode
