SOLVED
Home

Need FORMULA help please!!

%3CLINGO-SUB%20id%3D%22lingo-sub-779940%22%20slang%3D%22en-US%22%3ENeed%20FORMULA%20help%20please!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779940%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20Please%20help%20with%20formula%20in%20Col%20D%20Table%201%20to%20lookup%20values%20from%20Col%20H%20Table%202.%20Thank%20you%20in%20advance.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3ED%3C%2FTD%3E%3CTD%3EE%3C%2FTD%3E%3CTD%3EF%3C%2FTD%3E%3CTD%3EG%3C%2FTD%3E%3CTD%3EH%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3ETable%201%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ETable%202%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3EPRODUCT%20ID%3C%2FTD%3E%3CTD%3ECOMMENT%20CODE%3C%2FTD%3E%3CTD%3ECOMMENT%20DATE%3C%2FTD%3E%3CTD%3ELookup%20Value%3CBR%20%2F%3EFrom%20Table2%3CBR%20%2F%3E%26nbsp%3BColumn%20H%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EPRODUCT%20ID%3C%2FTD%3E%3CTD%3ECOMMENT%20CODE%3C%2FTD%3E%3CTD%3ECOMMENT%20DATE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E000101%3C%2FTD%3E%3CTD%3EABC1%3C%2FTD%3E%3CTD%3E02%2F04%2F2016%3C%2FTD%3E%3CTD%3E07%2F07%2F2019%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E000099%3C%2FTD%3E%3CTD%3EABC1%3C%2FTD%3E%3CTD%3E07%2F05%2F2019%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E000101%3C%2FTD%3E%3CTD%3EABC2%3C%2FTD%3E%3CTD%3E02%2F06%2F2016%3C%2FTD%3E%3CTD%3E07%2F08%2F2019%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E000100%3C%2FTD%3E%3CTD%3EABC2%3C%2FTD%3E%3CTD%3E07%2F06%2F2019%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E000103%3C%2FTD%3E%3CTD%3EABC1%3C%2FTD%3E%3CTD%3E02%2F06%2F2016%3C%2FTD%3E%3CTD%3E07%2F11%2F2019%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E000101%3C%2FTD%3E%3CTD%3EABC1%3C%2FTD%3E%3CTD%3E07%2F07%2F2019%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E000103%3C%2FTD%3E%3CTD%3EABC2%3C%2FTD%3E%3CTD%3E02%2F07%2F2016%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E000101%3C%2FTD%3E%3CTD%3EABC2%3C%2FTD%3E%3CTD%3E07%2F08%2F2019%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E000104%3C%2FTD%3E%3CTD%3EABC3%3C%2FTD%3E%3CTD%3E02%2F08%2F2016%3C%2FTD%3E%3CTD%3E07%2F07%2F2019%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E000103%3C%2FTD%3E%3CTD%3EABC1%3C%2FTD%3E%3CTD%3E07%2F11%2F2019%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E000103%3C%2FTD%3E%3CTD%3EABC2%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E000104%3C%2FTD%3E%3CTD%3EABC3%3C%2FTD%3E%3CTD%3E07%2F07%2F2019%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-779940%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eformula%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Evlookup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779982%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20FORMULA%20help%20please!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779982%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384531%22%20target%3D%22_blank%22%3E%40marislav%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20use%20below%20formula%20in%20Col%20D%20of%20Table%201%3A%3C%2FP%3E%3CP%3EVLOOKUP(C6%2C%24H%246%3A%24I%2412%2C2%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESample%20file%20is%20also%20attached%20for%20more%20understanding.%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779994%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20FORMULA%20help%20please!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779994%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384531%22%20target%3D%22_blank%22%3E%40marislav%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20for%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20552px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125005i3639418775EB8E4E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ein%20D4%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-ruby%22%3E%3CCODE%3E%3DIFERROR(INDEX(%24H%3A%24H%2CMATCH(1%2CINDEX((%24F%3A%24F%3D%24A4)*(%24G%3A%24G%3D%24B4)%2C0)%2C0))%2C%22no%20such%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780012%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20FORMULA%20help%20please!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780012%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20a%20lot%2C%26nbsp%3Bthat's%20what%20I%20need%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780027%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20FORMULA%20help%20please!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780027%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384531%22%20target%3D%22_blank%22%3E%40marislav%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
marislav
New Contributor

Hello, Please help with formula in Col D Table 1 to lookup values from Col H Table 2. Thank you in advance. 

 

1ABCDEFGH
2Table 1 Table 2
3PRODUCT IDCOMMENT CODECOMMENT DATELookup Value
From Table2
 Column H
 PRODUCT IDCOMMENT CODECOMMENT DATE
4000101ABC102/04/201607/07/2019 000099ABC107/05/2019
5000101ABC202/06/201607/08/2019 000100ABC207/06/2019
6000103ABC102/06/201607/11/2019 000101ABC107/07/2019
7000103ABC202/07/2016  000101ABC207/08/2019
8000104ABC302/08/201607/07/2019 000103ABC107/11/2019
9     000103ABC2 
10     000104ABC307/07/2019

 

4 Replies

Hi@marislav 

 

Please use below formula in Col D of Table 1:

VLOOKUP(C6,$H$6:$I$12,2,0)

 

Sample file is also attached for more understanding.

Thanks,

Tauqeer

Solution

@marislav 

As variant for

image.png

in D4

=IFERROR(INDEX($H:$H,MATCH(1,INDEX(($F:$F=$A4)*($G:$G=$B4),0),0)),"no such")

Thanks a lot, that's what I need @Sergei Baklan 

@marislav , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies