VLOOKUP against partial text within cell

[milo1234]

Hi, I would like to use a VLOOKUP for partial text within a cell. I have attempted the formula however this does not work. Please see sample data attached. Thank you

[#2 · Accepted solution]

@milo1234 

Perhaps

=INDEX(Table24[WP],MATCH(TRUE,INDEX(ISNUMBER(SEARCH(Table24[WP],[@Task])),),0))