SOLVED

VLOOKUP against partial text within cell

Contributor

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

1 Reply
best response confirmed by milo1234 (Contributor)
Solution

@milo1234 

Perhaps

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