Matching two range of value

V

vivian_pinto

New Member
Joined
Apr 25, 2016
Messages
10
[TABLE="width: 795"]
<colgroup><col span="11"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Dear All I am trying to get the result in excel like this.

please help me to get code at MATCHING COLUMN.

[TABLE="width: 795"]
<colgroup><col span="11"><col></colgroup><tbody>[TR]
[TD]RANGE1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RANGE2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]MATCHING[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NAME [/TD]
[TD]VALUE1[/TD]
[TD]VALUE2[/TD]
[TD][/TD]
[TD]NAME [/TD]
[TD]VALUE1[/TD]
[TD]VALUE2[/TD]
[TD][/TD]
[TD]ANSWER[/TD]
[TD]VALUE1[/TD]
[TD]VALUE2[/TD]
[TD]RESULT[/TD]
[/TR]
[TR]
[TD]CCC[/TD]
[TD]CC1[/TD]
[TD]CC11[/TD]
[TD][/TD]
[TD]BBB[/TD]
[TD]BB1[/TD]
[TD]BB11[/TD]
[TD][/TD]
[TD]CCC[/TD]
[TD]321[/TD]
[TD]CC11[/TD]
[TD]NOT MATCH[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]BB1[/TD]
[TD]BB11[/TD]
[TD][/TD]
[TD]EEE[/TD]
[TD]EE1[/TD]
[TD]EE11[/TD]
[TD][/TD]
[TD]BBB[/TD]
[TD]BB1[/TD]
[TD]BB11[/TD]
[TD]MATCH[/TD]
[/TR]
[TR]
[TD]DDD[/TD]
[TD]DD1[/TD]
[TD]DD11[/TD]
[TD][/TD]
[TD]CCC[/TD]
[TD]321[/TD]
[TD]CC11[/TD]
[TD][/TD]
[TD]DDD[/TD]
[TD]DD1[/TD]
[TD]555[/TD]
[TD]NOT MATCH[/TD]
[/TR]
[TR]
[TD]EEE[/TD]
[TD]EE1[/TD]
[TD]EE11[/TD]
[TD][/TD]
[TD]DDD[/TD]
[TD]DD1[/TD]
[TD]555[/TD]
[TD][/TD]
[TD]EEE[/TD]
[TD]EE1[/TD]
[TD]EE11[/TD]
[TD]MATCH
[/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes
[Table="width:, class:grid"][tr][td]Row\Col[/td][td]
A​
[/td][td]
B​
[/td][td]
C​
[/td][td]
D​
[/td][td]
E​
[/td][td]
F​
[/td][td]
G​
[/td][td]
H​
[/td][/tr]
[tr][td]
1​
[/td][td]RANGE1[/td][td][/td][td][/td][td][/td][td]RANGE2[/td][td][/td][td][/td][td]MATCHING[/td][/tr]


[tr][td]
2​
[/td][td]NAME[/td][td]VALUE1[/td][td]VALUE2[/td][td][/td][td]NAME[/td][td]VALUE1[/td][td]VALUE2[/td][td]ANSWER[/td][/tr]


[tr][td]
3​
[/td][td]CCC[/td][td]CC1[/td][td]CC11[/td][td][/td][td]BBB[/td][td]BB1[/td][td]BB11[/td][td]NOT MATCH[/td][/tr]


[tr][td]
4​
[/td][td]BBB[/td][td]BB1[/td][td]BB11[/td][td][/td][td]EEE[/td][td]EE1[/td][td]EE11[/td][td]MATCH[/td][/tr]


[tr][td]
5​
[/td][td]DDD[/td][td]DD1[/td][td]DD11[/td][td][/td][td]CCC[/td][td]
321​
[/td][td]CC11[/td][td]NOT MATCH[/td][/tr]


[tr][td]
6​
[/td][td]EEE[/td][td]EE1[/td][td]EE11[/td][td][/td][td]DDD[/td][td]DD1[/td][td]
555​
[/td][td]MATCH[/td][/tr]
[/table]

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"
 
Upvote 0
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
 
Upvote 0
I'd appreciate if we can resolve you seem to have here. Would you care to post a sample illustrating the problem?
 
Upvote 0
Aladin Akyurek said:
I'd appreciate if we can resolve you seem to have here. Would you care to post a sample illustrating the problem?
Click to expand...
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"




[TABLE="width: 904"]
<tbody>[TR]
[TD]PICTURE (Range 1)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EXCEL (Range2)[/TD]
[TD][/TD]
[TD][/TD]
[TD]

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

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]
A​
[/td][td]
B​
[/td][td]
C​
[/td][td]
D​
[/td][td]
E​
[/td][td]
F​
[/td][td]
G​
[/td][td]
H​
[/td][/tr]
[tr][td]
3​
[/td][td] C8311[/td][td] QXQQR-TMRJD-D8DKV-QM864-H8J49[/td][td] LW_TLEOL_26[/td][td] [/td][td] C8304[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_JNG_01[/td][td][/td][/tr]


[tr][td]
4​
[/td][td] C8316[/td][td] YK2DT-PV8QJ-8RFWQ-D3377-8M6W4[/td][td] LW_MIDLINE_01[/td][td] [/td][td] C8329[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_MIDLINERP_01[/td][td][/td][/tr]


[tr][td]
5​
[/td][td] C8317[/td][td] 6DWXV-7HWVF-2RQQV-FGB8Y-XD4DR[/td][td] LW_MIDLINE_03[/td][td] [/td][td] C8330[/td][td] V8BVT-PHQPT-39XWK-H6DVF-Q88PJ[/td][td] LW_MIDLINERP_02[/td][td][/td][/tr]


[tr][td]
6​
[/td][td] C8318[/td][td] CY7VQ-Y4PCP-C7QY7-QGWGY-VP9HG[/td][td] LW_MIDLINE_06[/td][td] [/td][td] C8305[/td][td] CMQ6P-M99YX-BH24C-8FJTF-PK42W[/td][td] [/td][td][/td][/tr]


[tr][td]
7​
[/td][td] C8323[/td][td] BGXY7-H8JPV-CYM7K-P7GRC-J6W3B[/td][td] LW_MIDLINE_07[/td][td] [/td][td] C8306[/td][td] VQMVD-99K6P-JCVDT-QJD7H-WVW8V[/td][td] LW_MIDLINE_01[/td][td][/td][/tr]


[tr][td]
8​
[/td][td] C8324[/td][td] BRR4K-V3C8F-RVX3F-6GQJW-3R6H2[/td][td] LW_MIDLINE_12[/td][td] [/td][td] C8307[/td][td] QYKF6-8VQTM-YVHY6-8WCR2-XKCTY[/td][td] LW_MIDLINE_03[/td][td][/td][/tr]


[tr][td]
9​
[/td][td] C8325[/td][td] JYR6R-D9KMR-PT8CJ-FY42F-7CK76[/td][td] LW_MIDLINE_13[/td][td] [/td][td] C8308[/td][td] FG9B6-9MHCY-7VMWM-996JW-7JQ8Q[/td][td] LW_MIDLINE_06[/td][td][/td][/tr]


[tr][td]
10​
[/td][td] C8340[/td][td] FCY29-6FDC7-HMFQQ-8FW62-9T4PB[/td][td] LW_MIDLINE_14[/td][td] [/td][td] [/td][td] J72DP-4QRR4-T4P3D-6FCVH-BDWTF[/td][td] LW_MIDLINE_05[/td][td][/td][/tr]


[tr][td]
11​
[/td][td] C8341[/td][td] YQ4XJ-JRWQB-YYH8J-428QB-7BGYT[/td][td] LW_MIDLINE_19[/td][td] [/td][td] C8310[/td][td] C9H9K-6F4W4-J77MF-T6JMP-XH3Q7[/td][td] [/td][td][/td][/tr]


[tr][td]
12​
[/td][td] C8342[/td][td] 238XY-8G3WD-PGBP8-XRXCX-9XG46[/td][td] LW_MIDLINE_20[/td][td] [/td][td] C8311[/td][td] QXQQR-TMRJD-D8DKV-QM864-H8J49[/td][td] LW_MIDLINE_07[/td][td][/td][/tr]


[tr][td]
13​
[/td][td] C8343[/td][td] W29WD-QQTM2-DYWCJ-H96WV-P8QWT[/td][td] LW_MIDLINE_21[/td][td] [/td][td] C8312[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_MIDLINE_08[/td][td][/td][/tr]


[tr][td]
14​
[/td][td] C8344[/td][td] TCVPF-22PPC-3CJM4-HKPK9-CHY4H[/td][td] LW_TLEOL_01[/td][td] [/td][td] C8313[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_MIDLINE_09[/td][td][/td][/tr]


[tr][td]
15​
[/td][td] C8345[/td][td] W9K2G-HPFXR-QJVPK-RMRMH-2GYVK[/td][td] LW_TLEOL_03[/td][td] [/td][td] C8314[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_MIDLINE_10[/td][td][/td][/tr]


[tr][td]
16​
[/td][td] C8346[/td][td] 49YRC-GH36C-YHG92-Q9CYC-6XCXQ[/td][td] LW_TLEOL_04[/td][td] [/td][td] C8315[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_MIDLINE_11[/td][td][/td][/tr]


[tr][td]
17​
[/td][td] C8347[/td][td] V8Y6J-R87K2-2PX6W-FGBTD-F22D6[/td][td] LW_TLEOL_05[/td][td] [/td][td] C8316[/td][td] YK2DT-PV8QJ-8RFWQ-D3377-8M6W4[/td][td] LW_MIDLINE_12[/td][td][/td][/tr]


[tr][td]
18​
[/td][td] C8348[/td][td] 6BDVY-8FWF8-3VM6Y-VB3QV-WY877[/td][td] LW_TLEOL_06[/td][td] [/td][td] C8317[/td][td] 6DWXV-7HWVF-2RQQV-FGB8Y-XD4DR[/td][td] LW_MIDLINE_13[/td][td][/td][/tr]


[tr][td]
19​
[/td][td] C8349[/td][td] BBG7M-7VY42-MCMBR-GFDMF-YHKV3[/td][td] LW_TLEOL_07[/td][td] [/td][td] C8318[/td][td] CY7VQ-Y4PCP-C7QY7-QGWGY-VP9HG[/td][td] LW_MIDLINE_14[/td][td][/td][/tr]


[tr][td]
20​
[/td][td] C8350[/td][td] 4DDX9-PMT37-4PH7H-BJH2M-8BT2K[/td][td] LW_TLEOL_08[/td][td] [/td][td] C8319[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_MIDLINE_15[/td][td][/td][/tr]


[tr][td]
21​
[/td][td] C8351[/td][td] 7MBQG-KRFW9-2F7CT-9KHTD-KFJBT[/td][td] LW_TLEOL_09[/td][td] [/td][td] C8320[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_MIDLINE_16[/td][td][/td][/tr]


[tr][td]
22​
[/td][td] C8352[/td][td] 34MJM-43W3H-6DVX7-P3396-JXHGM[/td][td] LW_TLEOL_10[/td][td] [/td][td] C8321[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_MIDLINE_17[/td][td][/td][/tr]


[tr][td]
23​
[/td][td] C8353[/td][td] TB43C-JVB9X-VBRY9-94947-C8CVD[/td][td] LW_TLEOL_12[/td][td] [/td][td] C8322[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_MIDLINE_18[/td][td][/td][/tr]


[tr][td]
24​
[/td][td] C8354[/td][td] PW478-Q4BFM-YKXDH-WY9TC-KKCKK[/td][td] LW_TLEOL_11[/td][td] [/td][td] C8323[/td][td] BGXY7-H8JPV-CYM7K-P7GRC-J6W3B[/td][td] LW_MIDLINE_19[/td][td][/td][/tr]


[tr][td]
25​
[/td][td] C8355[/td][td] FDK7Y-YKVTV-B2HC9-7T6JY-F63QC[/td][td] LW_TLEOL_13[/td][td] [/td][td] C8324[/td][td] BRR4K-V3C8F-RVX3F-6GQJW-3R6H2[/td][td] LW_MIDLINE_20[/td][td][/td][/tr]


[tr][td]
26​
[/td][td] C8356[/td][td] 6K97Y-GK8R8-B8V2B-Q77QM-J4HPJ[/td][td] LW_TLEOL_14[/td][td] [/td][td] C8325[/td][td] JYR6R-D9KMR-PT8CJ-FY42F-7CK76[/td][td] LW_MIDLINE_21[/td][td][/td][/tr]


[tr][td]
27​
[/td][td] C8357[/td][td] RGJCW-XGCRH-GRR76-M44CV-PR8VR[/td][td] LW_TLEOL_15[/td][td] [/td][td] C8326[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_MIDLINE_22[/td][td][/td][/tr]


[tr][td]
28​
[/td][td] C8359[/td][td] XFRPP-4DFXR-8M488-8BVQQ-GMBXK[/td][td] LW_TLEOL_16[/td][td] [/td][td] C8327[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_MIDLINE_23[/td][td][/td][/tr]


[tr][td]
29​
[/td][td] C8360[/td][td] HKWRQ-W4RXD-T6PWX-VMCY9-WCXRV[/td][td] LW_TLEOL_17[/td][td] [/td][td] C8328[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_MIDLINE_24[/td][td][/td][/tr]


[tr][td]
30​
[/td][td] C8361[/td][td] Q86MG-VHQQJ-W9TBJ-Y8F4P-79G4Y[/td][td] LW_TLEOL_18[/td][td] [/td][td] c8331[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CONTROL_01[/td][td][/td][/tr]


[tr][td]
31​
[/td][td] C8363[/td][td] P2PKC-979TV-P92JK-TVKQ7-V282B[/td][td] LW_TLEOL_19[/td][td] [/td][td] c8332[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CONTROL_02[/td][td][/td][/tr]


[tr][td]
32​
[/td][td] C8365[/td][td] 6R8C3-JWRHY-WWPP9-JCCHR-99X44[/td][td] LW_TLEOL_22[/td][td] [/td][td] c8333[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CONTROL_03[/td][td][/td][/tr]


[tr][td]
33​
[/td][td] C8366[/td][td] BVCFB-47QHW-8W7GC-CH7WM-7GQXX[/td][td] LW_TLEOL_21[/td][td] [/td][td] c8334[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CONTROL_04[/td][td][/td][/tr]


[tr][td]
34​
[/td][td] C8367[/td][td] 3Y4WY-YJH2H-Y426K-G8GPC-M4JRV[/td][td] LW_TLEOL_23[/td][td] [/td][td] c8335[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CONTROL_05[/td][td][/td][/tr]


[tr][td]
35​
[/td][td] C8368[/td][td] 87Q4M-VD94P-83JCM-H3VDV-B9TG8[/td][td] LW_TLEOL_25[/td][td] [/td][td] c8336[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CONTROL_06[/td][td][/td][/tr]


[tr][td]
36​
[/td][td] C8369[/td][td] CK8FC-DJYPF-49MCY-7FCWM-FJM34[/td][td] LW_TLEOL_27[/td][td] [/td][td] c8337[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CONTROL_07[/td][td][/td][/tr]


[tr][td]
37​
[/td][td] C8370[/td][td] FC42C-K72B4-8YMMP-Q9MQH-JDWCF[/td][td] LW_TLEOL_28[/td][td] [/td][td] c8338[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CONTROL_08[/td][td][/td][/tr]


[tr][td]
38​
[/td][td]
#VALUE!​
[/td][td] #VALUE![/td][td] LW_TLEOL_29[/td][td] [/td][td] [/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CONTROLRP_01[/td][td][/td][/tr]


[tr][td]
39​
[/td][td] NA[/td][td] FC4MM-RPHPK-JT2T4-9W7KT-HM6QP[/td][td] LW_TLEOL_30[/td][td] [/td][td] NA[/td][td] C8Y4Q-3M8PQ-7J8QB-C2XWD-XDXH4[/td][td] LX_TLEOL_02[/td][td][/td][/tr]


[tr][td]
40​
[/td][td] [/td][td] [/td][td] LW_TLEOL_32[/td][td] [/td][td] [/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] [/td][td][/td][/tr]


[tr][td]
41​
[/td][td] [/td][td] [/td][td] LW_TLEOL_31[/td][td] [/td][td] C8341[/td][td] YQ4XJ-JRWQB-YYH8J-428QB-7BGYT[/td][td] LW_TLEOL_03[/td][td][/td][/tr]


[tr][td]
42​
[/td][td] [/td][td] [/td][td] #VALUE![/td][td] [/td][td] C8342[/td][td] 238KY-8G3WD-PGBPB-XKXC2-9MQ46[/td][td] LW_TLEOL_04[/td][td][/td][/tr]


[tr][td]
43​
[/td][td] [/td][td] [/td][td] LW_TLEOL_02[/td][td] [/td][td] C8343[/td][td] W29WD-QQTM2-DYWCJ-H96WV-P8QWT[/td][td] LW_TLEOL_05[/td][td][/td][/tr]


[tr][td]
44​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8344[/td][td] TCVPF-22PPC-3CJM4-HKPK9-CHY4H[/td][td] LW_TLEOL_06[/td][td][/td][/tr]


[tr][td]
45​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8345[/td][td] W9K2G-HPFXR-QJVPK-RMRMH-2GYVK[/td][td] LW_TLEOL_07[/td][td][/td][/tr]


[tr][td]
46​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8346[/td][td] 49YRC-GH36C-YHG92-Q9CYC-6XCXQ[/td][td] LW_TLEOL_08[/td][td][/td][/tr]


[tr][td]
47​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8347[/td][td] V8Y6J-R87K2-2PX6W-FGBTD-F22D6[/td][td] LW_TLEOL_09[/td][td][/td][/tr]


[tr][td]
48​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8348[/td][td] 6BDVY-8FWF8-3VM6Y-VB3QV-WY877[/td][td] LW_TLEOL_10[/td][td][/td][/tr]


[tr][td]
49​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] YHPBV-CX62K-HGKJ8-4XJVB-7CTJ2[/td][td] [/td][td][/td][/tr]


[tr][td]
50​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8350[/td][td] 4DDX9-PMT37-4PH7H-BJH2M-8BT2K[/td][td] LW_TLEOL_11[/td][td][/td][/tr]


[tr][td]
51​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8351[/td][td] 7MBQG-KRFW9-2F7CT-9KHTD-KFJBT[/td][td] LW_TLEOL_13[/td][td][/td][/tr]


[tr][td]
52​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8352[/td][td] 34MJM-43W3H-6DVX7-P3396-JXMGM[/td][td] LW_TLEOL_14[/td][td][/td][/tr]


[tr][td]
53​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td][/td][/tr]


[tr][td]
54​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8354[/td][td] PW478-Q4BFM-YKXDH-WY9TC-KKCKK[/td][td] LW_TLEOL_16[/td][td][/td][/tr]


[tr][td]
55​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8355[/td][td] FDK7Y-YKVTV-B2HC9-7T6JY-F63QC[/td][td] LW_TLEOL_17[/td][td][/td][/tr]


[tr][td]
56​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8356[/td][td] 6K97Y-GK8R8-B8V2B-Q77QM-J4HPJ[/td][td] LW_TLEOL_18[/td][td][/td][/tr]


[tr][td]
57​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8357[/td][td] RGJCW-XGCRH-GRR76-M44CV-PR8VR[/td][td] LW_TLEOL_19[/td][td][/td][/tr]


[tr][td]
58​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8358[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_TLEOL_20[/td][td][/td][/tr]


[tr][td]
59​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8359[/td][td] XFRPP-4DFXR-8M488-8BVQQ-GMBXK[/td][td] LW_TLEOL_22[/td][td][/td][/tr]


[tr][td]
60​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8360[/td][td] HKWRQ-W4RXD-T6PWX-VMCY9-WCXRV[/td][td] LW_TLEOL_21[/td][td][/td][/tr]


[tr][td]
61​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8361[/td][td] Q86MG-VHQQJ-W9TBJ-Y8F4P-79G4Y[/td][td] LW_TLEOL_23[/td][td][/td][/tr]


[tr][td]
62​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8362[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_TLEOL_24[/td][td][/td][/tr]


[tr][td]
63​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8363[/td][td] P2PKC-979TV-P92JK-TVKQ7-V282B[/td][td] LW_TLEOL_25[/td][td][/td][/tr]


[tr][td]
64​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8364[/td][td] Q2BK9-38XB2-G9QMF-HP9Q9-7B6TP[/td][td] LX_MIDLINE_11[/td][td][/td][/tr]


[tr][td]
65​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8365[/td][td] 6R8C3-JWRHY-WWPP9-JCCHR-99X44[/td][td] LW_TLEOL_27[/td][td][/td][/tr]


[tr][td]
66​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8366[/td][td] BVCFB-47QHW-8W7GC-CH7WM-7GQXX[/td][td] LW_TLEOL_28[/td][td][/td][/tr]


[tr][td]
67​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8367[/td][td] 3Y4WY-YJH2H-Y426K-G8GPC-M4JRV[/td][td] LW_TLEOL_29[/td][td][/td][/tr]


[tr][td]
68​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8368[/td][td] 87Q4M-VD94P-83JCM-H3VDV-B9TG8[/td][td] LW_TLEOL_30[/td][td][/td][/tr]


[tr][td]
69​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8369[/td][td] CK8FC-DJYPF-49MCY-7FCWM-FJM34[/td][td] LW_TLEOL_32[/td][td][/td][/tr]


[tr][td]
70​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8370[/td][td] FC42C-K72B4-8YMMP-Q9MQH-JDWCF[/td][td] LW_TLEOL_31[/td][td][/td][/tr]


[tr][td]
71​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_HPM_01[/td][td][/td][/tr]


[tr][td]
72​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CSASELE_01[/td][td][/td][/tr]


[tr][td]
73​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CSA_01[/td][td][/td][/tr]


[tr][td]
74​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CSA_VFD_01[/td][td][/td][/tr]


[tr][td]
75​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CSA_VDF_02[/td][td][/td][/tr]


[tr][td]
76​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_TLEOLRP_01[/td][td][/td][/tr]


[tr][td]
77​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_TLEOLRP_02[/td][td][/td][/tr]


[tr][td]
78​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8395[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_TLEOLRP_03[/td][td][/td][/tr]


[tr][td]
79​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8396[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_TLEOLRP_04[/td][td][/td][/tr]


[tr][td]
80​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] MBF84-KW42H-BBGGT-CYY3D-FK28M[/td][td] LW_FUNCTION_01[/td][td][/td][/tr]


[tr][td]
81​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] KG2VK-WXJYY-4R4CY-X7HX4-8M2M3[/td][td] LW_FUNCTION_02[/td][td][/td][/tr]


[tr][td]
82​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] 4B4BP-WWQHX-BFPDQ-63HT7-6D3FB[/td][td] LW_FUNCTION_03[/td][td][/td][/tr]


[tr][td]
83​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8387[/td][td] V3P89-GR3RC-T4QB6-XB7RP-QMJ44[/td][td] LW_FUNCTION_04[/td][td][/td][/tr]


[tr][td]
84​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8388[/td][td] 9FM4X-3FCGX-3V38M-XB7RP-QMJ44[/td][td] LW_FUNCTION_05[/td][td][/td][/tr]


[tr][td]
85​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_CSA_PNS_03[/td][td][/td][/tr]


[tr][td]
86​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8389[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_PNS_01[/td][td][/td][/tr]


[tr][td]
87​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8390[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_PNS_02[/td][td][/td][/tr]


[tr][td]
88​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] C8391[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_PNS_03[/td][td][/td][/tr]


[tr][td]
89​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_COSMETIC_01[/td][td][/td][/tr]


[tr][td]
90​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8374[/td][td] RFJPT-34Y26-WJJJH-7DP80-37V24[/td][td] LW_PACKING_01[/td][td][/td][/tr]


[tr][td]
91​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8375[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_PACKING_02[/td][td][/td][/tr]


[tr][td]
92​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8376[/td][td] GQT8K-2BX83-C2M8G-FHW8K-QKG3P[/td][td] LW_PACKING_03[/td][td][/td][/tr]


[tr][td]
93​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8377[/td][td] H6JR4-MT3T3-88M4H-7GGKY-2RQD4[/td][td] LW_PACKING_04[/td][td][/td][/tr]


[tr][td]
94​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8378[/td][td] 74T2M-DKDBC-788W3-H689G-6P6GT[/td][td] LW_PACKING_05[/td][td][/td][/tr]


[tr][td]
95​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] c8379[/td][td] YB3HK-FRVDP-YKXXD-QGHP8-37YYM[/td][td] LW_PACKING_06[/td][td][/td][/tr]


[tr][td]
96​
[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] NA[/td][td] FC4MM-RPHPK-JT2T4-9W7KT-HM6QP[/td][td] LW_TLEOL_02[/td][td][/td][/tr]
[/table]
<strike></strike>
Care to specify the outcome in H3, H4, and H5? And how they obtain?
 
Upvote 0
HI, Aladin Akyurek
user-offline.png



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
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
VBA to identify matches in multiple columns and return values from matching rows in a different column, to another worksheet.
Replies
4
Views
3K
cjctmo
C
A
  • Question Question
VBA to copy entire row and paste in another sheet if condition is met
Replies
1
Views
489
Joe4
Joe4
A
  • Solved
If ,index , match
Replies
2
Views
470
Fluff
Fluff
L
  • Question Question
Copy selected cells paste to an inserted row below, some cells remain in same column, others will shift to different column based on value
Replies
0
Views
627
lascott
L
S
  • Question Question
Copy Data from 2 pivot table and make a new data set......
Replies
0
Views
541
sasils
S

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top