Index and Match with multiple criteria and wild card?

Hi all, is it possible to use wild cards in and Index and match array formula with multiple criteria?

This formula doesn't work, but hopefully it will illustrate what I'm trying to accomplish...

{=IFERROR(INDEX([Year],MATCH(1,([@[NC]]=[NC])*("*IMAGE"=[Project]),0)),0)}

I'm trying to match against two criteria, the current row value in the table column 'NC' and any row value containing the partial string "IMAGE" under the table column 'Project'

Here's an example of the table

NC Project Year Desired Result
100 IMAGE 2003 2003
100 PLATE 2005 2003
100 DUCK 2006 2003
200 IMAGE 2014 2014
200 DUCK 2020 2014

The Desired result column would contain the formula to return the Year value for the row where the NC value = the row NC value and the Project value contained the partial string "IMAGE"

Any assistance would be greatly appreciated!

Thanks

Try:

Formula:

Please Login or Register  to view this content.

Or just:

Formula:

Please Login or Register  to view this content.

You're welcome. Thanks for the rep.