I have a report that shows system generated errors. MOST of the errors are unique & I use them to categorize the errors to determine which work-groups they belong to via a table that has the errors & work-groups. My issue is that one of the errors always begins with "Carrier Billed", but from there it changes with value data specific to each error. That error is worked by the same work-group regardless, so I would like to just VLOOKUP that partial text to get my work-group. I'm open to non-VLOOKUP solutions, too.
Thanks in advance,
Susan
Thanks in advance,
Susan