Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup to find match only part of a text value
am trying to match two columns of data were column b has text values that
are very similar but not formatted exactly the same as column a. The slight formatting differences result null values on the vlookup. One solution for this challenge is to match the first 15 characters of a cell rather than the entire cell value. Can someone tell me how I can direct vlookup to look at a restricted character count? If vlookup isn't the right choose what is? For what it's worth, here's an example of the format challenge that's killing my vlookup. ABC Firm LLC vs. ABC Firm, LLC. Thanks! david |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
How do I use VLOOKUP to find part of string? | Excel Worksheet Functions | |||
find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
Find and replace part of a text string | Excel Discussion (Misc queries) | |||
If Match Part of Text Within Cell, Then Blank | Excel Worksheet Functions |