SOLVED

VLOOKUP against partial text within cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2475672%22%20slang%3D%22en-US%22%3EVLOOKUP%20against%20partial%20text%20within%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2475672%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20would%20like%20to%20use%20a%20VLOOKUP%20for%20partial%20text%20within%20a%20cell.%20I%20have%20attempted%20the%20formula%20however%20this%20does%20not%20work.%20Please%20see%20sample%20data%20attached.%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2475672%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2475904%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20against%20partial%20text%20within%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2475904%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F972444%22%20target%3D%22_blank%22%3E%40milo1234%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%3C%2FP%3E%0A%3CP%3E%3DINDEX(Table24%5BWP%5D%2CMATCH(TRUE%2CINDEX(ISNUMBER(SEARCH(Table24%5BWP%5D%2C%5B%40Task%5D))%2C)%2C0))%3C%2FP%3E%3C%2FLINGO-BODY%3E
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))