Hello all,
Long-time reader, first-time poster. I need to find and extract a string from a text field that consists of two letters followed by three numbers (XX000) then nest that inside a VLOOKUP to return another corresponding cell of data. There are hundreds of rows of data that need this applied to them Sample data below:
<tbody>
</tbody>
The VLOOKUP with the XX000 string is easy; pulling that string using a formula and no VBA is the hard part. Someone please tell me there's an easy way that I'm simply overlooking!
Edit: I just discovered that I may also have a master list of the strings that are embedded in the Comment column. Sample below:
<tbody>
</tbody>
So the end goal is to find the purchaser (Table 2) from the code (Table 1 & 2) taken from the text field (Table 1).
Thanks to everyone who checks this out!
____________
Jawnathin
Long-time reader, first-time poster. I need to find and extract a string from a text field that consists of two letters followed by three numbers (XX000) then nest that inside a VLOOKUP to return another corresponding cell of data. There are hundreds of rows of data that need this applied to them Sample data below:
Created | Comment | Desired Extraction |
1/1/2013 | Bananas BA426 Them more text | BA426 |
5/1/2013 | Apples AP654 More additional text | AP654 |
6/3/2013 | More Fruit MF055 Even more text | MF055 |
7/5/2013 | More Text Before Numbers MT323 and this one is going to be really long to prove a point. | MT323 |
<tbody>
</tbody>
The VLOOKUP with the XX000 string is easy; pulling that string using a formula and no VBA is the hard part. Someone please tell me there's an easy way that I'm simply overlooking!
Edit: I just discovered that I may also have a master list of the strings that are embedded in the Comment column. Sample below:
Code | Purchaser | |
BA426 | Jill | |
AP654 | Adam | |
MF055 | Fred | |
MT323 | Charles |
<tbody>
</tbody>
So the end goal is to find the purchaser (Table 2) from the code (Table 1 & 2) taken from the text field (Table 1).
Thanks to everyone who checks this out!
____________
Jawnathin
Last edited: