VLOOKUP using wildcard on non-static data

I'm wondering if there is a way to perform a VLOOKUP function on data that isn't always an exact match - possibly using a wildcard feature? We have a report that shows errors on accounts that need to be worked daily. Based on the type of error, determines which department is responsible for working the error. Many times, these errors have dates in them, as well as different charge codes. The other tricky thing is that the Error description field does not always have these non-static data elements in the same location....they are scattered throughout the description. I have a table that I am referencing, that lists all of the errors, and which department is responsible. Obviously, my table will not have every possible charge code and date in it, so it can't find a match. Any help will be GREATLY appreciated!

I am trying to perform a VLOOKUP in column I, against the Error Table on the next tab. As you can see, my vlookup didn't return any data because there was no exact matches. I forgot that the sample I sent you I had overwritten the VLOOKUP statment and just manually typed in the responsible department. Sorry about that.

That worked on a few of them, but the ones that say "Invalid date on date ....", it returns FALSE. I have attached the new updated file to show what I mean.

I don't understand what the above formula is actually doing, but is there not a way to use a wildcard? When I typed that into my spreadsheet, it worked on a few of the errors, but not all. Thanks!

I have updated my schedule, so that you can see all of the errors that weren't able to return the correct value.

This was my original question...is there a way to perform a vlookup function that utilizes a wildcard, so that if the edit descriptions were slightly different each day, it would still be able to determine which department should work it. Are you saying that in my Error table, if I have several of the same error, as long as I replace the changing pieces to a "*", my lookup function would work?