Hi all, spent nearly a day on this one and was hoping someone could help me out.
I am currently doing some data management for a company and need to get a specific function working with Vlookup which should save a few days work.
I currently have all the file names in a single column e.g.
800GR_FOP.psd
800GR_TOP.psd
I need to be able to isolate the _FOP and _TOP part so that when it looks at my Vlookup table, it returns a value such as 'FOP Image' into a new column and 'TOP Image" into the same column (but horizontal to its original file name.
There are a few variations, so maybe an OR function will come in handy e.g. _TOP, _BOP - what I am having trouble with is isolating multiple isolated parts of strings in order to return the desired value.
Thanks
I am currently doing some data management for a company and need to get a specific function working with Vlookup which should save a few days work.
I currently have all the file names in a single column e.g.
800GR_FOP.psd
800GR_TOP.psd
I need to be able to isolate the _FOP and _TOP part so that when it looks at my Vlookup table, it returns a value such as 'FOP Image' into a new column and 'TOP Image" into the same column (but horizontal to its original file name.
There are a few variations, so maybe an OR function will come in handy e.g. _TOP, _BOP - what I am having trouble with is isolating multiple isolated parts of strings in order to return the desired value.
Thanks