Mike;
Thanks for your help with the above. After I figured out what you were trying to do, it was a breeze to incorporate.
Works a treat - really appreciate the help.
Deepak
Mike;
Your assumptions are correct:
- the original column is from a freeform field and therefore I'm trying to categorise each line using the 2nd "mapping" table
- once there is a 'match' in the 1st column of the 2nd table, there needs to be no further analysis (so if it finds 'VCG' it just...
An example of what I'm trying to do - I'st set of data is what where I'm searching within the cell :
165T VCG Jul 05 - HK
4468 VCG Aug 05 - TOK
4019 VCG Aug 05 - AUS
266Q VCG May 05 - TOK
MTM V MTT diff
MTM adj
PWO Prov
BON Provision
CER provision
I then want to use a static stable that looks...
I need to use something similar to the textsearch/textextract functions above, but is is possible to have the text search as a range (so searching for multiple strings within text) and returning just the string on which I can use a vlookup function.
The function above seems so close, yet I just...
