SOLVED

I Need formula in Cell D21 & G21

%3CLINGO-SUB%20id%3D%22lingo-sub-1959929%22%20slang%3D%22en-US%22%3EI%20Need%20formula%20in%20Cell%20D21%20%26amp%3B%20G21%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959929%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20attached%20file%20is%20self%20explanatory.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20Need%20formula%20in%20Cell%20D21%20%26amp%3B%20G21.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1959929%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959987%22%20slang%3D%22en-US%22%3ERe%3A%20I%20Need%20formula%20in%20Cell%20D21%20%26amp%3B%20G21%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959987%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578075%22%20target%3D%22_blank%22%3E%40Oliullah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20suggest%20updating%20your%20request%20to%20make%20it%20easier%20for%20someone%20who%20is%20having%20a%20similar%20issue%20as%20you%20to%20find%20this%20post.%20Since%20you%20already%20have%20the%20Unique%20IDs%20in%20the%20DD%20List%20tab%2C%20the%20formula%20you're%20looking%20for%20is%20VLOOKUP%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DVLOOKUP(D22%2C%24M%2418%3A%24O%2424%2C3%2CTRUE)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22adversi_1-1607251752197.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238075iA1A81D8654C45268%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22adversi_1-1607251752197.png%22%20alt%3D%22adversi_1-1607251752197.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959994%22%20slang%3D%22en-US%22%3ERe%3A%20I%20Need%20formula%20in%20Cell%20D21%20%26amp%3B%20G21%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959994%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867265%22%20target%3D%22_blank%22%3E%40adversi%3C%2FA%3E%26nbsp%3BThanks%20a%20lot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1961818%22%20slang%3D%22en-US%22%3ERe%3A%20I%20Need%20formula%20in%20Cell%20D21%20%26amp%3B%20G21%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1961818%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867265%22%20target%3D%22_blank%22%3E%40adversi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20select%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22102%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22102%22%3E1011030534981%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22102%22%3E1011030534970%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20shows%20an%20error%20message.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20help%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20be%20expecting%20for%20your%20kind%20response.%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1962280%22%20slang%3D%22en-US%22%3ERe%3A%20I%20Need%20formula%20in%20Cell%20D21%20%26amp%3B%20G21%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1962280%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578075%22%20target%3D%22_blank%22%3E%40Oliullah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20since%20last%20parameter%20is%20TRUE%20(approximate%20match).%20Please%20change%20on%20FALSE.%20Even%20better%20is%20to%20use%20XLOOKUP%20or%20INDEX%2FMATCH.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1962630%22%20slang%3D%22en-US%22%3ERe%3A%20I%20Need%20formula%20in%20Cell%20D21%20%26amp%3B%20G21%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1962630%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578075%22%20target%3D%22_blank%22%3E%40Oliullah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20mentioned%20by%20Sergei%2C%20the%20last%20part%20of%20the%20formula%20should%20be%20changed%20to%20FALSE.%20I%20made%20the%20edit%20to%20the%20previous%20post%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

The attached file is self explanatory.

 

I Need formula in Cell D21 & G21.

 

Please help me.

 

Thanks in advance.

7 Replies

@Oliullah 

I would suggest updating your request to make it easier for someone who is having a similar issue as you to find this post. Since you already have the Unique IDs in the DD List tab, the formula you're looking for is VLOOKUP:

 

=VLOOKUP(D22,$M$18:$O$24,3,FALSE)

 

FALSE = Exact Match

TRUE = Approximate Match

 

adversi_1-1607251752197.png

@adversi Thanks a lot.

@adversi 

 

Hello, 

 

When I select, 

 

1011030534981
1011030534970

 

Excel shows an error message.

 

Could you please help again.

 

Would be expecting for your kind response.

Thanks.

Best Response confirmed by Oliullah (Occasional Contributor)
Solution

@Oliullah 

That's since last parameter is TRUE (approximate match). Please change on FALSE. Even better is to use XLOOKUP or INDEX/MATCH.

@Oliullah 

As mentioned by Sergei, the last part of the formula should be changed to FALSE. I made the edit to the previous post

@adversi Thank you

@Sergei Baklan Thank you