match data between two sheets based on three columns together & arrange again

A

abdo meghari

Well-known Member
Joined
Aug 3, 2021
Messages
635
Office Version
  1. 2019
hello

I have two sheets . the sheet STOCK depends on right data are existed in sheet .so if there is different data in sheet STOCK and not matched with data in sheet MAIN based on COLUMN B,C,D together , then should replace data in sheet STOCK based on sheet MAIN .as you see in sheet STOCK is highlighted by blue some items are duplicte and some are wrong. breifly it should correct data in sheet STOCK based on sheet MAIN . so I put the result in sheet RESULT , but it sould show in sheet STOCK.
thanks
SST (1).xls
ABCDEFG
1JANUARY
2CategorySizePatternOrigin Arrived SalesStock
3175/70R13EP150THI862
4185/70R13EP150INDO2368
5175/65R14EP150INDO5--11259
6175/70R14EP150THI239
7175/70R14MY02THI141
8185/65R14TECTHI8657
9185/65R14EP150INDO81,607
10185/65R15T005INDO91
11185/65R15T01INDO100
12185/65R15B250INDO60
13195/60R15AR20INDO9
14195/60R15EP150THI468
15195/60R15T001THI50
16195/65R15EP150THI6
17195/65R15EP150THI4142
18195/55R16EP300THI92
19205/65R15EP150INDO196
20205/65R15MY02THI358
21205/65R15T01THI100
22FS 205/65R15TZ700THI3
23215/65R15T005 INDO58
24205/70R15694INDO16
25235/95R15CD618INDO56
26255/70R15CD840THI692
27205R16C D840THI120
28205/R16CD697THI413
29205/55R16ER300POL482
30215/55R16EP300INDO174
31215/60R16EP300THI1475
32215/60R16EP200THI14
33215/60R16T005THI599
34215/60R16AR20INDO2
35215/65R16AR20INDO4
36225/60R16EP300INDO192
37225/60R16T001INDO50
38235/60R16T01INDO100
39245/70R16D684THI60
40255/70R16T697INDO1
41255/70R16H005THI152
42265/70R16D850THI423
43265/70R16D840THI496
44275/70R16H005THI4
45275/70R16D694THI30
46PSR (HRD)215/45R17T001THI86
47215/50R17EP300THI430
48215/55R17GR90INDO139
49215/55R17T001INDO100
50215/55R17TECTHI4
51215/55R17MY02THI480
52FS 215/55R17TZ700THI62
53225/45R17RE050ATHI26
54225/45R17RE003THI1
55FS 225/45R17TZ700THI33
56FS 225/55R17TZ700THI16
57225/55R17EP300THI21
58225/55R17D694THI32
59225/60R17D-SPORTTHI20
60225/65R17T697INDO24
61225/70R17D697THI50
62235/55R17ER30THI29
63235/55R17T005THI71
64235/55R17D400THI12
65235/60R17D400THI12
66235/65R17T697INDO8
67245/45R17T05AINDO32
68245/65R17D698INDO50
69245/65R17D697INDO24
70245/70R17D684INDO50
71245/75R17693AINDO831
72265/65R17D840INDO100
73225/40R18GR90INDO32
74225/40R18GR90INDO28
75225/45R18AR20INDO22
76235/60R18D-SPORTINDO2
77245/40R18RE050AINDO21
78245/45R18T001INDO424
79255/35R18GR90INDO10
80275/35R18RE050AINDO14
81275/40R18RE050AINDO10
82275/65R18116HTHI4
83285/60R18T01THI50
84285/60R18D850THI66
85245/40R20RE050THI13
86265/50R20SPORTTHI58
87275/30R20RE050THI2
88275/55R20D680THI16
89285/30R20RE0050ATHI14
90315/35R20SPORTTHI3
91LTR650R16R2302
92700R16R23012PR42177
MAIN




SST (1).xls
ABCDEFG
1JANUARY
2CategorySizePatternOrigin Arrived SalesStock
3175/70R13EP150THI862
4175/70R13EP150THI862
5185/70R13EP150JAP2368
6185/70R13EP150INDO2368
7175/65R14EP150INDO5--11259
8175/70R14EP150THI239
9175/70R14MY02THI141
10185/65R14TECTHI8657
11185/65R14EP150THI81,607
12185/65R15T005INDO91
13185/65R15T01INDO100
14185/65R15B250INDO60
15195/60R15AR20INDO9
16195/60R15EP150THI468
17195/60R15T001THI50
18195/65R15EP150THI6
19195/65R15EP150THI4142
20195/55R16EP300THI92
21205/65R15EP150INDO196
22205/65R15MY02THI358
23205/65R15T01THI100
24FS 205/65R15TZ700THI3
25215/65R15T005 INDO58
26205/70R15694INDO16
27235/95R15CD618INDO56
28255/70R15CD840THI692
29205R16C D840THI120
30205/R16CD697THI413
31205/55R16ER300POL482
32215/55R16EP300INDO174
33215/60R16EP300THI1475
34215/60R16EP200THI14
35215/60R16T005THI599
36215/60R16AR20INDO2
37215/65R16AR20INDO4
38225/60R16EP300INDO192
39225/60R16T001INDO50
40235/60R16T01INDO100
41PSR (HRD)245/70R16D684THI60
42255/70R16T697INDO1
43255/70R16H005THI152
44265/70R16D850THI423
45265/70R16D840THI496
46275/70R16H005THI4
47275/70R16D694THI30
48215/45R17T001THI86
49215/50R17EP300THI430
50215/55R17GR90INDO139
51215/55R17T001INDO100
52215/55R17TECTHI4
53215/55R17MY02THI480
54FS 215/55R17TZ700THI62
55225/45R17RE050ATHI26
56225/45R17RE003THI1
57FS 225/45R17TZ700THI33
58FS 225/55R17TZ700THI16
59225/55R17EP300THI21
60225/55R17D694THI32
61225/60R17D-SPORTTHI20
62225/65R17T697INDO24
63225/70R17D697THI50
64235/55R17ER30THI29
65235/55R17T005THI71
66235/55R17D400THI12
67235/60R17D400THI12
68235/65R17T697INDO8
69245/45R17T05AINDO32
70245/65R17D698INDO50
71245/65R17D697INDO24
72245/70R17D684INDO50
73245/75R17693AINDO831
74265/65R17D840INDO100
75225/40R18GR90INDO32
76225/40R18GR90INDO28
77225/45R18AR20INDO22
78235/60R18D-SPORTINDO2
79245/40R18RE050AINDO21
80245/45R18T001INDO424
81255/35R18GR90INDO10
82275/35R18RE050AINDO14
83275/40R18RE050AINDO10
84275/65R18116HTHI4
85285/60R18T01THI50
86285/60R18D850THI66
87LTR245/40R20RE050THI13
88265/50R20SPORTTHI58
89275/30R20RE050THI2
90275/55R20D680THI16
91285/30R20RE0050ATHI14
92315/35R20SPORTTHI3
93650R16R2302
94700R16R23012PR42177
STOCK




SST (1).xls
ABCDEFG
1JANUARY
2CategorySizePatternOrigin Arrived SalesStock
3175/70R13EP150THI862
4185/70R13EP150INDO2368
5175/65R14EP150INDO5--11259
6175/70R14EP150THI239
7175/70R14MY02THI141
8185/65R14TECTHI8657
9185/65R14EP150INDO81,607
10185/65R15T005INDO91
11185/65R15T01INDO100
12185/65R15B250INDO60
13195/60R15AR20INDO9
14195/60R15EP150THI468
15195/60R15T001THI50
16195/65R15EP150THI6
17195/65R15EP150THI4142
18195/55R16EP300THI92
19205/65R15EP150INDO196
20205/65R15MY02THI358
21205/65R15T01THI100
22FS 205/65R15TZ700THI3
23215/65R15T005 INDO58
24205/70R15694INDO16
25235/95R15CD618INDO56
26255/70R15CD840THI692
27205R16C D840THI120
28205/R16CD697THI413
29205/55R16ER300POL482
30215/55R16EP300INDO174
31215/60R16EP300THI1475
32215/60R16EP200THI14
33215/60R16T005THI599
34215/60R16AR20INDO2
35215/65R16AR20INDO4
36225/60R16EP300INDO192
37225/60R16T001INDO50
38235/60R16T01INDO100
39245/70R16D684THI60
40255/70R16T697INDO1
41255/70R16H005THI152
42265/70R16D850THI423
43265/70R16D840THI496
44275/70R16H005THI4
45275/70R16D694THI30
46PSR (HRD)215/45R17T001THI86
47215/50R17EP300THI430
48215/55R17GR90INDO139
49215/55R17T001INDO100
50215/55R17TECTHI4
51215/55R17MY02THI480
52FS 215/55R17TZ700THI62
53225/45R17RE050ATHI26
54225/45R17RE003THI1
55FS 225/45R17TZ700THI33
56FS 225/55R17TZ700THI16
57225/55R17EP300THI21
58225/55R17D694THI32
59225/60R17D-SPORTTHI20
60225/65R17T697INDO24
61225/70R17D697THI50
62235/55R17ER30THI29
63235/55R17T005THI71
64235/55R17D400THI12
65235/60R17D400THI12
66235/65R17T697INDO8
67245/45R17T05AINDO32
68245/65R17D698INDO50
69245/65R17D697INDO24
70245/70R17D684INDO50
71245/75R17693AINDO831
72265/65R17D840INDO100
73225/40R18GR90INDO32
74225/40R18GR90INDO28
75225/45R18AR20INDO22
76235/60R18D-SPORTINDO2
77245/40R18RE050AINDO21
78245/45R18T001INDO424
79255/35R18GR90INDO10
80275/35R18RE050AINDO14
81275/40R18RE050AINDO10
82275/65R18116HTHI4
83285/60R18T01THI50
84285/60R18D850THI66
85245/40R20RE050THI13
86265/50R20SPORTTHI58
87275/30R20RE050THI2
88275/55R20D680THI16
89285/30R20RE0050ATHI14
90315/35R20SPORTTHI3
91LTR650R16R2302
92700R16R23012PR42177
93
MAIN
 
Last edited:

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

A
  • Question Question
merge XLSX files for same sheet name based on specific files names
3 4 5
Replies
40
Views
609
abdo meghari
A
P
  • Question Question
Matching an ID from 2 columns in 2 worksheets to then produce the figure from a 3rd column.
Replies
4
Views
331
Pavesib
P
B
  • Solved
Extract data based on a criteria
2
Replies
11
Views
403
smozgur
smozgur
M
  • Question Question
Create Report across sheets based on two dates as in my attachment
Replies
0
Views
143
Maklil
M
A
  • Question Question
populate & update invoice information across sheets based on invoice number
Replies
0
Views
338
abdo meghari
A

Forum statistics

Threads
1,224,524
Messages
6,179,308
Members
452,904
Latest member
CodeMasterX

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