Index array - partial match

Hi There,

I am new here.

I have an excel problem i cannot solve.

So i have created a formula that needs to match the pin number in cell B9 to the same pin number in column G, then search column M to find the row that contains the phrase in cell E9, then return the value from the same row in column P which will be a date.

The problem i have is if the phrase exists exactly in in column M it works perfectly, unfortunately i need it to find the phrase as a partial match for example, Cell M12 has the text "Detailed design" so as the word "detailed" is found i would like it to return the value in cell P12, in this case the date 03/09/2018

Its like i need E9 to be a wildcard?

The formula i currently have is

=IFERROR(INDEX($P$2:$P$4981,MATCH(1,($B9=$G$2:$G$4981)*(E9=$M$2:$M$4981),0)),"")

pic.jpgAttachment 831921Book1.xlsx

Yes this is perfect, exactly what i needed! Thank you so much, spent hours trying to figure it out.

Yes i am going to have other separate matches so this works perfectly for what i am using.

Thanks again