I am so excited to find this forum because I need some formula assistance.
I have two worksheets containing data that I need to compare to validate that an entry on worksheet CON has a corresponding entry on worksheet SAW. I would use Vlookup, except the data I need to compare in SAW is included in a long string of text.
The formula or combination of proceedures and formula needs to be able to find c00709364 in the text string "RIP Manager (5K) (ID: emr_na-c00723764-1) " and return a TRUE (or FALSE if not found.)
Here is a couple of entry examples from the two worksheets:
Compare
CON data to SAW data
c00709364 RIP Manager (26K) (ID: emr_na-c00726155-1)
c00710005 Managing Presses (7K) (ID: emr_na-c00726192-1)
c00711679 Installing Remote Manager (2K) (ID: emr_na-c00711679-1)
c00726192 RIP Manager (5K) (ID: emr_na-c00723764-1)
I hope this is understandable.
Thanks for your help.
jahli
I have two worksheets containing data that I need to compare to validate that an entry on worksheet CON has a corresponding entry on worksheet SAW. I would use Vlookup, except the data I need to compare in SAW is included in a long string of text.
The formula or combination of proceedures and formula needs to be able to find c00709364 in the text string "RIP Manager (5K) (ID: emr_na-c00723764-1) " and return a TRUE (or FALSE if not found.)
Here is a couple of entry examples from the two worksheets:
Compare
CON data to SAW data
c00709364 RIP Manager (26K) (ID: emr_na-c00726155-1)
c00710005 Managing Presses (7K) (ID: emr_na-c00726192-1)
c00711679 Installing Remote Manager (2K) (ID: emr_na-c00711679-1)
c00726192 RIP Manager (5K) (ID: emr_na-c00723764-1)
I hope this is understandable.
Thanks for your help.
jahli