INDEX - MATCH on two Criteria with wildcard

I would like to do an INDEX / MATCH function or something similar for the following to return a date from 'Sheet2'

This formula works without a wildcard in text string search, however if a wildcard is inserted then the formula comes back '#N/A'. Is there something similar I can use? SUMPRODUCT?

In attached file I have included TABLE 1 (Wildcard Formula) and TABLE 2 (No Wildcard Formula) to show it works without a wildcard.

EDIT: FYI my separators I use is | since I use various codes in MS project as well. Use normal comma's and I'll transfer anything over. Sorry for any confusion.

Formula:

Please Login or Register  to view this content.

WILDCARD INDEX.xlsx

Try that. The decision to use an array formula.