# Matching two range of value

#### vivian_pinto

##### New Member

<colgroup><col span="11"><col></colgroup><tbody>
</tbody>
Dear All I am trying to get the result in excel like this.

 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

<colgroup><col span="11"><col></colgroup><tbody>
</tbody>

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

##### MrExcel MVP
 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"

#### vivian_pinto

##### New Member

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

##### MrExcel MVP
I'd appreciate if we can resolve you seem to have here. Would you care to post a sample illustrating the problem?

#### vivian_pinto

##### New Member
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

<tbody>
</tbody>

##### MrExcel MVP
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
<strike></strike>
Care to specify the outcome in H3, H4, and H5? And how they obtain?

#### vivian_pinto

##### New Member
HI,

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

##### MrExcel MVP
[...]

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?