Matching two range of value

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Matching two range of value

  1. #1
    New Member
    Join Date
    Apr 2016
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Matching two range of value

     
    Dear All I am trying to get the result in excel like this.

    please help me to get code at MATCHING COLUMN.

    RANGE1 RANGE2 MATCHING
    NAME VALUE1 VALUE2 NAME VALUE1 VALUE2 ANSWER VALUE1 VALUE2 RESULT
    CCC CC1 CC11 BBB BB1 BB11 CCC 321 CC11 NOT MATCH
    BBB BB1 BB11 EEE EE1 EE11 BBB BB1 BB11 MATCH
    DDD DD1 DD11 CCC 321 CC11 DDD DD1 555 NOT MATCH
    EEE EE1 EE11 DDD DD1 555 EEE EE1 EE11 MATCH

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,006
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Matching two range of value

    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    1
    RANGE1 RANGE2 MATCHING
    2
    NAME VALUE1 VALUE2 NAME VALUE1 VALUE2 ANSWER
    3
    CCC CC1 CC11 BBB BB1 BB11 NOT MATCH
    4
    BBB BB1 BB11 EEE EE1 EE11 MATCH
    5
    DDD DD1 DD11 CCC
    321
    CC11 NOT MATCH
    6
    EEE EE1 EE11 DDD DD1
    555
    MATCH


    In H3 enter and copy down:

    =IF(B3&"|"&C3=INDEX($F$3:$F$6&"|"&$G$3:$G$6,MATCH(A3,$E$3:$E$6,0)),"","NOT ")&"MATCH"
    Assuming too much and qualifying too much are two faces of the same problem.

  3. #3
    New Member
    Join Date
    Apr 2016
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Matching two range of value

    Mr. Aladin AkyurekFantastic solution .

    Thank you very much

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,006
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Matching two range of value

    Quote Originally Posted by vivian_pinto View Post
    Mr. Aladin AkyurekFantastic solution .

    Thank you very much
    You are welcome.
    Assuming too much and qualifying too much are two faces of the same problem.

  5. #5
    New Member
    Join Date
    Apr 2016
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Matching two range of value

    Hi, Aladin Akyruek,

    Actually your code for selected data has worked out.

    But the logic behind is comparing one range of data with other. Its not actually working on my sheet.


    Range1 and Range2 are compared on this concept.

    E3 and its related values (F3 AND G3 ) are matched with range of $A$1000:$E$1000.

    if E3 found in the range, then Is F3 and G3 are matching with values found in that row.

    I want to attach my excel file pleas give me your email .


    Thank you

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,006
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Matching two range of value

    I'd appreciate if we can resolve you seem to have here. Would you care to post a sample illustrating the problem?
    Assuming too much and qualifying too much are two faces of the same problem.

  7. #7
    New Member
    Join Date
    Apr 2016
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Matching two range of value

    Quote Originally Posted by Aladin Akyurek View Post
    I'd appreciate if we can resolve you seem to have here. Would you care to post a sample illustrating the problem?
    I am not able to attach picture or file. Written code in H column is =IF(F3&"|"&G3=INDEX($B$2:$B$2998&"|"&$C$2:$C$298,MATCH(F3,$E$2:$E$2998,0)),"","NOT ")&"MATCH"




    PICTURE (Range 1) EXCEL (Range2)
    1 1 1 1 1 MATCH
    A B C D E F G NOT MATCH
    C8311 QXQQR-TMRJD-D8DKV-QM864-H8J49 LW_TLEOL_26 C8304 74T2M-DKDBC-788W3-H689G-6P6GT LW_JNG_01 #N/A
    C8316 YK2DT-PV8QJ-8RFWQ-D3377-8M6W4 LW_MIDLINE_01 C8329 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINERP_01 #N/A
    C8317 6DWXV-7HWVF-2RQQV-FGB8Y-XD4DR LW_MIDLINE_03 C8330 V8BVT-PHQPT-39XWK-H6DVF-Q88PJ LW_MIDLINERP_02 #N/A
    C8318 CY7VQ-Y4PCP-C7QY7-QGWGY-VP9HG LW_MIDLINE_06 C8305 CMQ6P-M99YX-BH24C-8FJTF-PK42W #N/A
    C8323 BGXY7-H8JPV-CYM7K-P7GRC-J6W3B LW_MIDLINE_07 C8306 VQMVD-99K6P-JCVDT-QJD7H-WVW8V LW_MIDLINE_01 #N/A
    C8324 BRR4K-V3C8F-RVX3F-6GQJW-3R6H2 LW_MIDLINE_12 C8307 QYKF6-8VQTM-YVHY6-8WCR2-XKCTY LW_MIDLINE_03 #N/A
    C8325 JYR6R-D9KMR-PT8CJ-FY42F-7CK76 LW_MIDLINE_13 C8308 FG9B6-9MHCY-7VMWM-996JW-7JQ8Q LW_MIDLINE_06 #N/A
    C8340 FCY29-6FDC7-HMFQQ-8FW62-9T4PB LW_MIDLINE_14 J72DP-4QRR4-T4P3D-6FCVH-BDWTF LW_MIDLINE_05 #N/A
    C8341 YQ4XJ-JRWQB-YYH8J-428QB-7BGYT LW_MIDLINE_19 C8310 C9H9K-6F4W4-J77MF-T6JMP-XH3Q7 #N/A
    C8342 238XY-8G3WD-PGBP8-XRXCX-9XG46 LW_MIDLINE_20 C8311 QXQQR-TMRJD-D8DKV-QM864-H8J49 LW_MIDLINE_07 #N/A
    C8343 W29WD-QQTM2-DYWCJ-H96WV-P8QWT LW_MIDLINE_21 C8312 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_08 #N/A
    C8344 TCVPF-22PPC-3CJM4-HKPK9-CHY4H LW_TLEOL_01 C8313 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_09 #N/A
    C8345 W9K2G-HPFXR-QJVPK-RMRMH-2GYVK LW_TLEOL_03 C8314 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_10 #N/A
    C8346 49YRC-GH36C-YHG92-Q9CYC-6XCXQ LW_TLEOL_04 C8315 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_11 #N/A
    C8347 V8Y6J-R87K2-2PX6W-FGBTD-F22D6 LW_TLEOL_05 C8316 YK2DT-PV8QJ-8RFWQ-D3377-8M6W4 LW_MIDLINE_12 #N/A
    C8348 6BDVY-8FWF8-3VM6Y-VB3QV-WY877 LW_TLEOL_06 C8317 6DWXV-7HWVF-2RQQV-FGB8Y-XD4DR LW_MIDLINE_13 #N/A
    C8349 BBG7M-7VY42-MCMBR-GFDMF-YHKV3 LW_TLEOL_07 C8318 CY7VQ-Y4PCP-C7QY7-QGWGY-VP9HG LW_MIDLINE_14 #N/A
    C8350 4DDX9-PMT37-4PH7H-BJH2M-8BT2K LW_TLEOL_08 C8319 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_15 #N/A
    C8351 7MBQG-KRFW9-2F7CT-9KHTD-KFJBT LW_TLEOL_09 C8320 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_16 #N/A
    C8352 34MJM-43W3H-6DVX7-P3396-JXHGM LW_TLEOL_10 C8321 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_17 #N/A
    C8353 TB43C-JVB9X-VBRY9-94947-C8CVD LW_TLEOL_12 C8322 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_18 #N/A
    C8354 PW478-Q4BFM-YKXDH-WY9TC-KKCKK LW_TLEOL_11 C8323 BGXY7-H8JPV-CYM7K-P7GRC-J6W3B LW_MIDLINE_19 #N/A
    C8355 FDK7Y-YKVTV-B2HC9-7T6JY-F63QC LW_TLEOL_13 C8324 BRR4K-V3C8F-RVX3F-6GQJW-3R6H2 LW_MIDLINE_20 #N/A
    C8356 6K97Y-GK8R8-B8V2B-Q77QM-J4HPJ LW_TLEOL_14 C8325 JYR6R-D9KMR-PT8CJ-FY42F-7CK76 LW_MIDLINE_21 #N/A
    C8357 RGJCW-XGCRH-GRR76-M44CV-PR8VR LW_TLEOL_15 C8326 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_22 #N/A
    C8359 XFRPP-4DFXR-8M488-8BVQQ-GMBXK LW_TLEOL_16 C8327 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_23 #N/A
    C8360 HKWRQ-W4RXD-T6PWX-VMCY9-WCXRV LW_TLEOL_17 C8328 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_24 #N/A
    C8361 Q86MG-VHQQJ-W9TBJ-Y8F4P-79G4Y LW_TLEOL_18 c8331 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_01 #N/A
    C8363 P2PKC-979TV-P92JK-TVKQ7-V282B LW_TLEOL_19 c8332 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_02 #N/A
    C8365 6R8C3-JWRHY-WWPP9-JCCHR-99X44 LW_TLEOL_22 c8333 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_03 #N/A
    C8366 BVCFB-47QHW-8W7GC-CH7WM-7GQXX LW_TLEOL_21 c8334 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_04 #N/A
    C8367 3Y4WY-YJH2H-Y426K-G8GPC-M4JRV LW_TLEOL_23 c8335 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_05 #N/A
    C8368 87Q4M-VD94P-83JCM-H3VDV-B9TG8 LW_TLEOL_25 c8336 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_06 #N/A
    C8369 CK8FC-DJYPF-49MCY-7FCWM-FJM34 LW_TLEOL_27 c8337 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_07 #N/A
    C8370 FC42C-K72B4-8YMMP-Q9MQH-JDWCF LW_TLEOL_28 c8338 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_08 #N/A
    #VALUE! #VALUE! LW_TLEOL_29 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROLRP_01 #N/A
    NA FC4MM-RPHPK-JT2T4-9W7KT-HM6QP LW_TLEOL_30 NA C8Y4Q-3M8PQ-7J8QB-C2XWD-XDXH4 LX_TLEOL_02 #N/A
    LW_TLEOL_32 74T2M-DKDBC-788W3-H689G-6P6GT #N/A
    LW_TLEOL_31 C8341 YQ4XJ-JRWQB-YYH8J-428QB-7BGYT LW_TLEOL_03 #N/A
    #VALUE! C8342 238KY-8G3WD-PGBPB-XKXC2-9MQ46 LW_TLEOL_04 #N/A
    LW_TLEOL_02 C8343 W29WD-QQTM2-DYWCJ-H96WV-P8QWT LW_TLEOL_05 #N/A
    C8344 TCVPF-22PPC-3CJM4-HKPK9-CHY4H LW_TLEOL_06 #N/A
    C8345 W9K2G-HPFXR-QJVPK-RMRMH-2GYVK LW_TLEOL_07 #N/A
    C8346 49YRC-GH36C-YHG92-Q9CYC-6XCXQ LW_TLEOL_08 #N/A
    C8347 V8Y6J-R87K2-2PX6W-FGBTD-F22D6 LW_TLEOL_09 #N/A
    C8348 6BDVY-8FWF8-3VM6Y-VB3QV-WY877 LW_TLEOL_10 #N/A
    YHPBV-CX62K-HGKJ8-4XJVB-7CTJ2 #N/A
    C8350 4DDX9-PMT37-4PH7H-BJH2M-8BT2K LW_TLEOL_11 #N/A
    C8351 7MBQG-KRFW9-2F7CT-9KHTD-KFJBT LW_TLEOL_13 #N/A
    C8352 34MJM-43W3H-6DVX7-P3396-JXMGM LW_TLEOL_14 #N/A
    #N/A
    C8354 PW478-Q4BFM-YKXDH-WY9TC-KKCKK LW_TLEOL_16 #N/A
    C8355 FDK7Y-YKVTV-B2HC9-7T6JY-F63QC LW_TLEOL_17 #N/A
    C8356 6K97Y-GK8R8-B8V2B-Q77QM-J4HPJ LW_TLEOL_18 #N/A
    C8357 RGJCW-XGCRH-GRR76-M44CV-PR8VR LW_TLEOL_19 #N/A
    c8358 74T2M-DKDBC-788W3-H689G-6P6GT LW_TLEOL_20 #N/A
    C8359 XFRPP-4DFXR-8M488-8BVQQ-GMBXK LW_TLEOL_22 #N/A
    C8360 HKWRQ-W4RXD-T6PWX-VMCY9-WCXRV LW_TLEOL_21 #N/A
    C8361 Q86MG-VHQQJ-W9TBJ-Y8F4P-79G4Y LW_TLEOL_23 #N/A
    c8362 74T2M-DKDBC-788W3-H689G-6P6GT LW_TLEOL_24 #N/A
    C8363 P2PKC-979TV-P92JK-TVKQ7-V282B LW_TLEOL_25 #N/A
    C8364 Q2BK9-38XB2-G9QMF-HP9Q9-7B6TP LX_MIDLINE_11 #N/A
    c8365 6R8C3-JWRHY-WWPP9-JCCHR-99X44 LW_TLEOL_27 #N/A
    c8366 BVCFB-47QHW-8W7GC-CH7WM-7GQXX LW_TLEOL_28 #N/A
    c8367 3Y4WY-YJH2H-Y426K-G8GPC-M4JRV LW_TLEOL_29 #N/A
    C8368 87Q4M-VD94P-83JCM-H3VDV-B9TG8 LW_TLEOL_30 #N/A
    c8369 CK8FC-DJYPF-49MCY-7FCWM-FJM34 LW_TLEOL_32 #N/A
    c8370 FC42C-K72B4-8YMMP-Q9MQH-JDWCF LW_TLEOL_31 #N/A
    74T2M-DKDBC-788W3-H689G-6P6GT LW_HPM_01 #N/A
    74T2M-DKDBC-788W3-H689G-6P6GT LW_CSASELE_01 #N/A
    74T2M-DKDBC-788W3-H689G-6P6GT LW_CSA_01 #N/A
    74T2M-DKDBC-788W3-H689G-6P6GT LW_CSA_VFD_01 #N/A
    74T2M-DKDBC-788W3-H689G-6P6GT LW_CSA_VDF_02 #N/A
    74T2M-DKDBC-788W3-H689G-6P6GT LW_TLEOLRP_01 #N/A
    74T2M-DKDBC-788W3-H689G-6P6GT LW_TLEOLRP_02 #N/A
    c8395 74T2M-DKDBC-788W3-H689G-6P6GT LW_TLEOLRP_03 #N/A
    c8396 74T2M-DKDBC-788W3-H689G-6P6GT LW_TLEOLRP_04 #N/A
    MBF84-KW42H-BBGGT-CYY3D-FK28M LW_FUNCTION_01 #N/A
    KG2VK-WXJYY-4R4CY-X7HX4-8M2M3 LW_FUNCTION_02 #N/A
    4B4BP-WWQHX-BFPDQ-63HT7-6D3FB LW_FUNCTION_03 #N/A
    C8387 V3P89-GR3RC-T4QB6-XB7RP-QMJ44 LW_FUNCTION_04 #N/A
    C8388 9FM4X-3FCGX-3V38M-XB7RP-QMJ44 LW_FUNCTION_05 #N/A
    74T2M-DKDBC-788W3-H689G-6P6GT LW_CSA_PNS_03 #N/A
    C8389 74T2M-DKDBC-788W3-H689G-6P6GT LW_PNS_01 #N/A
    C8390 74T2M-DKDBC-788W3-H689G-6P6GT LW_PNS_02 #N/A
    C8391 74T2M-DKDBC-788W3-H689G-6P6GT LW_PNS_03 #N/A
    74T2M-DKDBC-788W3-H689G-6P6GT LW_COSMETIC_01 #N/A
    c8374 RFJPT-34Y26-WJJJH-7DP80-37V24 LW_PACKING_01 #N/A
    c8375 74T2M-DKDBC-788W3-H689G-6P6GT LW_PACKING_02 #N/A
    c8376 GQT8K-2BX83-C2M8G-FHW8K-QKG3P LW_PACKING_03 #N/A
    c8377 H6JR4-MT3T3-88M4H-7GGKY-2RQD4 LW_PACKING_04 #N/A
    c8378 74T2M-DKDBC-788W3-H689G-6P6GT LW_PACKING_05 #N/A
    c8379 YB3HK-FRVDP-YKXXD-QGHP8-37YYM LW_PACKING_06 #N/A
    NA FC4MM-RPHPK-JT2T4-9W7KT-HM6QP LW_TLEOL_02 #N/A

  8. #8
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,006
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Matching two range of value

    You posted...

    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    3
    C8311 QXQQR-TMRJD-D8DKV-QM864-H8J49 LW_TLEOL_26 C8304 74T2M-DKDBC-788W3-H689G-6P6GT LW_JNG_01
    4
    C8316 YK2DT-PV8QJ-8RFWQ-D3377-8M6W4 LW_MIDLINE_01 C8329 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINERP_01
    5
    C8317 6DWXV-7HWVF-2RQQV-FGB8Y-XD4DR LW_MIDLINE_03 C8330 V8BVT-PHQPT-39XWK-H6DVF-Q88PJ LW_MIDLINERP_02
    6
    C8318 CY7VQ-Y4PCP-C7QY7-QGWGY-VP9HG LW_MIDLINE_06 C8305 CMQ6P-M99YX-BH24C-8FJTF-PK42W
    7
    C8323 BGXY7-H8JPV-CYM7K-P7GRC-J6W3B LW_MIDLINE_07 C8306 VQMVD-99K6P-JCVDT-QJD7H-WVW8V LW_MIDLINE_01
    8
    C8324 BRR4K-V3C8F-RVX3F-6GQJW-3R6H2 LW_MIDLINE_12 C8307 QYKF6-8VQTM-YVHY6-8WCR2-XKCTY LW_MIDLINE_03
    9
    C8325 JYR6R-D9KMR-PT8CJ-FY42F-7CK76 LW_MIDLINE_13 C8308 FG9B6-9MHCY-7VMWM-996JW-7JQ8Q LW_MIDLINE_06
    10
    C8340 FCY29-6FDC7-HMFQQ-8FW62-9T4PB LW_MIDLINE_14 J72DP-4QRR4-T4P3D-6FCVH-BDWTF LW_MIDLINE_05
    11
    C8341 YQ4XJ-JRWQB-YYH8J-428QB-7BGYT LW_MIDLINE_19 C8310 C9H9K-6F4W4-J77MF-T6JMP-XH3Q7
    12
    C8342 238XY-8G3WD-PGBP8-XRXCX-9XG46 LW_MIDLINE_20 C8311 QXQQR-TMRJD-D8DKV-QM864-H8J49 LW_MIDLINE_07
    13
    C8343 W29WD-QQTM2-DYWCJ-H96WV-P8QWT LW_MIDLINE_21 C8312 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_08
    14
    C8344 TCVPF-22PPC-3CJM4-HKPK9-CHY4H LW_TLEOL_01 C8313 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_09
    15
    C8345 W9K2G-HPFXR-QJVPK-RMRMH-2GYVK LW_TLEOL_03 C8314 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_10
    16
    C8346 49YRC-GH36C-YHG92-Q9CYC-6XCXQ LW_TLEOL_04 C8315 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_11
    17
    C8347 V8Y6J-R87K2-2PX6W-FGBTD-F22D6 LW_TLEOL_05 C8316 YK2DT-PV8QJ-8RFWQ-D3377-8M6W4 LW_MIDLINE_12
    18
    C8348 6BDVY-8FWF8-3VM6Y-VB3QV-WY877 LW_TLEOL_06 C8317 6DWXV-7HWVF-2RQQV-FGB8Y-XD4DR LW_MIDLINE_13
    19
    C8349 BBG7M-7VY42-MCMBR-GFDMF-YHKV3 LW_TLEOL_07 C8318 CY7VQ-Y4PCP-C7QY7-QGWGY-VP9HG LW_MIDLINE_14
    20
    C8350 4DDX9-PMT37-4PH7H-BJH2M-8BT2K LW_TLEOL_08 C8319 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_15
    21
    C8351 7MBQG-KRFW9-2F7CT-9KHTD-KFJBT LW_TLEOL_09 C8320 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_16
    22
    C8352 34MJM-43W3H-6DVX7-P3396-JXHGM LW_TLEOL_10 C8321 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_17
    23
    C8353 TB43C-JVB9X-VBRY9-94947-C8CVD LW_TLEOL_12 C8322 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_18
    24
    C8354 PW478-Q4BFM-YKXDH-WY9TC-KKCKK LW_TLEOL_11 C8323 BGXY7-H8JPV-CYM7K-P7GRC-J6W3B LW_MIDLINE_19
    25
    C8355 FDK7Y-YKVTV-B2HC9-7T6JY-F63QC LW_TLEOL_13 C8324 BRR4K-V3C8F-RVX3F-6GQJW-3R6H2 LW_MIDLINE_20
    26
    C8356 6K97Y-GK8R8-B8V2B-Q77QM-J4HPJ LW_TLEOL_14 C8325 JYR6R-D9KMR-PT8CJ-FY42F-7CK76 LW_MIDLINE_21
    27
    C8357 RGJCW-XGCRH-GRR76-M44CV-PR8VR LW_TLEOL_15 C8326 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_22
    28
    C8359 XFRPP-4DFXR-8M488-8BVQQ-GMBXK LW_TLEOL_16 C8327 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_23
    29
    C8360 HKWRQ-W4RXD-T6PWX-VMCY9-WCXRV LW_TLEOL_17 C8328 74T2M-DKDBC-788W3-H689G-6P6GT LW_MIDLINE_24
    30
    C8361 Q86MG-VHQQJ-W9TBJ-Y8F4P-79G4Y LW_TLEOL_18 c8331 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_01
    31
    C8363 P2PKC-979TV-P92JK-TVKQ7-V282B LW_TLEOL_19 c8332 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_02
    32
    C8365 6R8C3-JWRHY-WWPP9-JCCHR-99X44 LW_TLEOL_22 c8333 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_03
    33
    C8366 BVCFB-47QHW-8W7GC-CH7WM-7GQXX LW_TLEOL_21 c8334 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_04
    34
    C8367 3Y4WY-YJH2H-Y426K-G8GPC-M4JRV LW_TLEOL_23 c8335 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_05
    35
    C8368 87Q4M-VD94P-83JCM-H3VDV-B9TG8 LW_TLEOL_25 c8336 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_06
    36
    C8369 CK8FC-DJYPF-49MCY-7FCWM-FJM34 LW_TLEOL_27 c8337 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_07
    37
    C8370 FC42C-K72B4-8YMMP-Q9MQH-JDWCF LW_TLEOL_28 c8338 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROL_08
    38
    #VALUE!
    #VALUE! LW_TLEOL_29 74T2M-DKDBC-788W3-H689G-6P6GT LW_CONTROLRP_01
    39
    NA FC4MM-RPHPK-JT2T4-9W7KT-HM6QP LW_TLEOL_30 NA C8Y4Q-3M8PQ-7J8QB-C2XWD-XDXH4 LX_TLEOL_02
    40
    LW_TLEOL_32 74T2M-DKDBC-788W3-H689G-6P6GT
    41
    LW_TLEOL_31 C8341 YQ4XJ-JRWQB-YYH8J-428QB-7BGYT LW_TLEOL_03
    42
    #VALUE! C8342 238KY-8G3WD-PGBPB-XKXC2-9MQ46 LW_TLEOL_04
    43
    LW_TLEOL_02 C8343 W29WD-QQTM2-DYWCJ-H96WV-P8QWT LW_TLEOL_05
    44
    C8344 TCVPF-22PPC-3CJM4-HKPK9-CHY4H LW_TLEOL_06
    45
    C8345 W9K2G-HPFXR-QJVPK-RMRMH-2GYVK LW_TLEOL_07
    46
    C8346 49YRC-GH36C-YHG92-Q9CYC-6XCXQ LW_TLEOL_08
    47
    C8347 V8Y6J-R87K2-2PX6W-FGBTD-F22D6 LW_TLEOL_09
    48
    C8348 6BDVY-8FWF8-3VM6Y-VB3QV-WY877 LW_TLEOL_10
    49
    YHPBV-CX62K-HGKJ8-4XJVB-7CTJ2
    50
    C8350 4DDX9-PMT37-4PH7H-BJH2M-8BT2K LW_TLEOL_11
    51
    C8351 7MBQG-KRFW9-2F7CT-9KHTD-KFJBT LW_TLEOL_13
    52
    C8352 34MJM-43W3H-6DVX7-P3396-JXMGM LW_TLEOL_14
    53
    54
    C8354 PW478-Q4BFM-YKXDH-WY9TC-KKCKK LW_TLEOL_16
    55
    C8355 FDK7Y-YKVTV-B2HC9-7T6JY-F63QC LW_TLEOL_17
    56
    C8356 6K97Y-GK8R8-B8V2B-Q77QM-J4HPJ LW_TLEOL_18
    57
    C8357 RGJCW-XGCRH-GRR76-M44CV-PR8VR LW_TLEOL_19
    58
    c8358 74T2M-DKDBC-788W3-H689G-6P6GT LW_TLEOL_20
    59
    C8359 XFRPP-4DFXR-8M488-8BVQQ-GMBXK LW_TLEOL_22
    60
    C8360 HKWRQ-W4RXD-T6PWX-VMCY9-WCXRV LW_TLEOL_21
    61
    C8361 Q86MG-VHQQJ-W9TBJ-Y8F4P-79G4Y LW_TLEOL_23
    62
    c8362 74T2M-DKDBC-788W3-H689G-6P6GT LW_TLEOL_24
    63
    C8363 P2PKC-979TV-P92JK-TVKQ7-V282B LW_TLEOL_25
    64
    C8364 Q2BK9-38XB2-G9QMF-HP9Q9-7B6TP LX_MIDLINE_11
    65
    c8365 6R8C3-JWRHY-WWPP9-JCCHR-99X44 LW_TLEOL_27
    66
    c8366 BVCFB-47QHW-8W7GC-CH7WM-7GQXX LW_TLEOL_28
    67
    c8367 3Y4WY-YJH2H-Y426K-G8GPC-M4JRV LW_TLEOL_29
    68
    C8368 87Q4M-VD94P-83JCM-H3VDV-B9TG8 LW_TLEOL_30
    69
    c8369 CK8FC-DJYPF-49MCY-7FCWM-FJM34 LW_TLEOL_32
    70
    c8370 FC42C-K72B4-8YMMP-Q9MQH-JDWCF LW_TLEOL_31
    71
    74T2M-DKDBC-788W3-H689G-6P6GT LW_HPM_01
    72
    74T2M-DKDBC-788W3-H689G-6P6GT LW_CSASELE_01
    73
    74T2M-DKDBC-788W3-H689G-6P6GT LW_CSA_01
    74
    74T2M-DKDBC-788W3-H689G-6P6GT LW_CSA_VFD_01
    75
    74T2M-DKDBC-788W3-H689G-6P6GT LW_CSA_VDF_02
    76
    74T2M-DKDBC-788W3-H689G-6P6GT LW_TLEOLRP_01
    77
    74T2M-DKDBC-788W3-H689G-6P6GT LW_TLEOLRP_02
    78
    c8395 74T2M-DKDBC-788W3-H689G-6P6GT LW_TLEOLRP_03
    79
    c8396 74T2M-DKDBC-788W3-H689G-6P6GT LW_TLEOLRP_04
    80
    MBF84-KW42H-BBGGT-CYY3D-FK28M LW_FUNCTION_01
    81
    KG2VK-WXJYY-4R4CY-X7HX4-8M2M3 LW_FUNCTION_02
    82
    4B4BP-WWQHX-BFPDQ-63HT7-6D3FB LW_FUNCTION_03
    83
    C8387 V3P89-GR3RC-T4QB6-XB7RP-QMJ44 LW_FUNCTION_04
    84
    C8388 9FM4X-3FCGX-3V38M-XB7RP-QMJ44 LW_FUNCTION_05
    85
    74T2M-DKDBC-788W3-H689G-6P6GT LW_CSA_PNS_03
    86
    C8389 74T2M-DKDBC-788W3-H689G-6P6GT LW_PNS_01
    87
    C8390 74T2M-DKDBC-788W3-H689G-6P6GT LW_PNS_02
    88
    C8391 74T2M-DKDBC-788W3-H689G-6P6GT LW_PNS_03
    89
    74T2M-DKDBC-788W3-H689G-6P6GT LW_COSMETIC_01
    90
    c8374 RFJPT-34Y26-WJJJH-7DP80-37V24 LW_PACKING_01
    91
    c8375 74T2M-DKDBC-788W3-H689G-6P6GT LW_PACKING_02
    92
    c8376 GQT8K-2BX83-C2M8G-FHW8K-QKG3P LW_PACKING_03
    93
    c8377 H6JR4-MT3T3-88M4H-7GGKY-2RQD4 LW_PACKING_04
    94
    c8378 74T2M-DKDBC-788W3-H689G-6P6GT LW_PACKING_05
    95
    c8379 YB3HK-FRVDP-YKXXD-QGHP8-37YYM LW_PACKING_06
    96
    NA FC4MM-RPHPK-JT2T4-9W7KT-HM6QP LW_TLEOL_02


    Care to specify the outcome in H3, H4, and H5? And how they obtain?
    Assuming too much and qualifying too much are two faces of the same problem.

  9. #9
    New Member
    Join Date
    Apr 2016
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Matching two range of value

    HI, Aladin Akyurek



    Column H should specify me like this.

    if E3 found in the range of $A$3:$A$40, then .... in this example E25 found at A8

    now I want to compare E25:F25:G25 with A8:B8:C8 and here

    A8:B8 is matching but but C8.. So the result should "Not Match"


    If any of the three values are matching with other 3 values then its "Match"


    i am just comparing each values of EFG with ABC


    Thankyou

  10. #10
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,006
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Matching two range of value

      
    Quote Originally Posted by vivian_pinto View Post

    [...]

    i am just comparing each values of EFG with ABC

    [...]
    1. Why do we have a #VALUE! error in A38 and in B38?

    2. Why are the ranges in A, in B, and in C not equally sized?
    Assuming too much and qualifying too much are two faces of the same problem.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com