Vlookup formula for word.

%3CLINGO-SUB%20id%3D%22lingo-sub-2142523%22%20slang%3D%22en-US%22%3EVlookup%20formula%20for%20word.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142523%22%20slang%3D%22en-US%22%3E%3CP%3EDear's%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20help%20me%20for%20the%20below%20one%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20to%20data%20file%201.submit%2C%202%2CReq.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esubmit%20(320%20list)%2C%3C%2FP%3E%3CP%3EReq%20(1000%20list)%2C%20both%20not%20same%20company%20so%20here%20i%20have%20to%20find%20the%20Req%20to%20submit%20file..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20one%20help%20me%20the%20formula%2C%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20attched%20below%20file%20also%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2142523%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2142707%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20formula%20for%20word.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142707%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F931234%22%20target%3D%22_blank%22%3E%40SUDHAKAR-FRONTIER%3C%2FA%3E%26nbsp%3BThere%20is%20no%20direct%20way%20to%20doing%20a%20partial%20word%20match%2C%20you%20will%20have%20to%20install%20Fuzzy%20Lookup%20to%20control%20the%20%22match%22.%20You%20can%20read%20more%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fusing-match-function-without-the-exact-match%2Fm-p%2F1949637%22%20target%3D%22_self%22%3Ehere%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Dear's,

 

Can help me for the below one ,

 

I have to data file 1.submit, 2,Req.

 

submit (320 list),

Req (1000 list), both not same company so here i have to find the Req to submit file..

 

Any one help me the formula, 

i attched below file also

 

2 Replies

@SUDHAKAR-FRONTIER There is no direct way to doing a partial word match, you will have to install Fuzzy Lookup to control the "match". You can read more here

@SUDHAKAR-FRONTIER 

Look at the inserted file, maybe that's what you are looking for

 

 

Cheers,

Nikolino