| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vlookup for part of a word
I have three columns of information.
column A - 6 digit number column B - 8 digit number and dash that correspond to column A column C - 6 digit number with other data that match one of the entries from column A I would like column D to give the result from column B that corresponds to column A based on the data from column C and if it matches (partially) column A. example A B C D 050505 04-121212 050505 - CO.fsa (formula here) 050452 05-214176 050505 - CO.fsa 052121 03-217496 050505 - CO.fsa In this example, I would like column D result to be 04-121212 for all three entries because that it the number listed in column C. In this instance, I would like column D to return 04-121212 for all three answers. So, I want the results from column C that go with Colum |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
| How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
| Vlookup of parts of a word in a range of Data | Excel Discussion (Misc queries) | |||
Threaded Mode
