Sheet Comparison/Auto fill

[MThies]

I need to do a price comparison of products. I have a list of some products where the price hasn't been changed in awhile. Using the full-main product list, I want to compare the two lists to see what prices are correct/incorrect. Using the item #'s, is there a way I can automatically import the prices from the main list, next to the corresponding products in the other list? I read about trying a Vlookup but I'm not sure if I can get the prices to fill next to the items.

Thank you for your help,

 

[Joe4]

Welcome to the Board!

In order to help you set this up, we really need to see the structure of your two lists.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[MThies]

I need to do a price comparison of products. I have a list of some products where the price hasn't been changed in awhile. Using the full-main product list, I want to compare the two lists to see what prices are correct/incorrect. Using the item #'s, is there a way I can automatically import the prices from the main list, next to the corresponding products in the other list? I read about trying a Vlookup but I'm not sure if I can get the prices to fill next to the items.

Thank you for your help,

I need to do a price comparison of products. I have a list of some products where the price hasn't been changed in awhile. Using the full-main product list, I want to compare the two lists to see what prices are correct/incorrect. Using the item #'s, is there a way I can automatically import the prices from the main list, next to the corresponding products in the other list? I read about trying a Vlookup but I'm not sure if I can get the prices to fill next to the items.

Thank you for your help,

Eostar price book 9.1.21.xlsx
	A	B	C
1	Item #	Product	Base price
2	58777	Product 1	28.00
3	58734	Product 2	78.00
4	58711	Product 3	28.00
5	58779	Product 4	89.00
6	58762	Product 5	89.00
7	58787	Product 6	33.00
8	58729	Product 7	28.00
9	58703	Product 8	28.00
10	58716	Product 9	135.00
11	58742	Product 10	80.00
12	58702	Product 11	28.00
13	58728	Product 12	28.00
14	58749	Product 13	78.00
15	58712	Product 14	28.00
16	59306	Product 15	28.00
17	58704	Product 16	28.00
18	58714	Product 17	30.00
19	98004	Product 18	112.00
20	98001	Product 19	40.00
21	98007	Product 20	40.00
22	98002	Product 21	89.00
23	98005	Product 22	85.00
24	98006	Product 23	135.00
25	98003	Product 24	85.00
26	54928	Product 25	63.00
27	54953	Product 26	48.00
28	54931	Product 27	230.00
29	54946	Product 28	105.00
30	54945	Product 29	63.00
31	54973	Product 30	63.00
32	54972	Product 31	48.00
33	54970	Product 32	48.00
34	63013	Product 33	29.00
35	49703	Product 34	153.00
36	49702	Product 35	66.00
37	49740	Product 36	23.50
38	49708	Product 37	29.50
39	49704	Product 38	29.50
40	49747	Product 39	29.50
41	49700	Product 40	23.45
42	49701	Product 41	31.45
43	49710	Product 42	34.00
44	49750	Product 43	31.45
45	49716	Product 44	31.45
46	49751	Product 45	31.45
47	49744	Product 46	29.50
48	49743	Product 47	34.00
49	49739	Product 48	31.45
50	49752	Product 49	31.45
51	49734	Product 50	29.50
52	49753	Product 51	29.50
53	49746	Product 52	29.50
54	79743	Product 53	45.00
55	62641	Product 54	26.80
56	62642	Product 55	30.60
57	62640	Product 56	26.80
58	06000	Product 57	20.40
59	06002	Product 58	25.50
60	06001	Product 59	24.00
61	98701	Product 60	30.00
62	40520	Product 61	175.00
63	40502	Product 62	53.00
64	40503	Product 63	175.00
65	40505	Product 64	53.00
66	40514	Product 65	61.00
67	40507	Product 66	53.00
68	40513	Product 67	53.00
69	40515	Product 68	150.00
70	40518	Product 69	53.00
71	82023	Product 70	25.50
72	93122	Product 71	48.48
73	99990	Product 72	125.00
74	68188	Product 73	21.00
75	68213	Product 74	27.20
76	65035	Product 75	170.00
77	65016	Product 76	98.00
78	65094	Product 77	29.50
79	65021	Product 78	40.95
80	65212	Product 79	34.00
81	65015	Product 80	34.00
82	65078	Product 81	38.95
83	68207	Product 82	59.00
84	65001	Product 83	31.00
85	65221	Product 84	179.00
86	64197	Product 85	105.00
87	65195	Product 86	36.00
88	65103	Product 87	129.00
89	65059	Product 88	158.00
90	65029	Product 89	85.00
91	68189	Product 90	31.00
92	1066	Product 91	31.00
93	68206	Product 92	31.00
94	65027	Product 93	31.00
95	65080	Product 94	34.90
96	68216	Product 95	34.00
97	65075	Product 96	105.84
98	68190	Product 97	125.00
99	68175	Product 98	158.00
100	68176	Product 99	85.00
101	68174	Product 100	31.00
102	68173	Product 101	31.00
103	68210	Product 102	31.00
104	68171	Product 103	31.00
105	68172	Product 104	34.90
106	53893	Product 105	196.00
107	65068	Product 106	125.00
108	65020	Product 107	49.00
109	65047	Product 108	160.00
110	65032	Product 109	90.00
111	65017	Product 110	34.00
112	10086	Product 111	155.00
113	40431	Product 112	169.00
114	65031	Product 113	105.00
115	65030	Product 114	36.00
116	65172	Product 115	145.00
117	68187	Product 116	50.10
118	65019	Product 117	140.00
119	64999	Product 118	170.00
120	64998	Product 119	98.00
121	65000	Product 120	34.00
122	77381	Product 121	78.75
123	65046	Product 122	120.00
124	68212	Product 123	29.50
125	65008	Product 124	235.00
126	65009	Product 125	145.00
127	10422	Product 126	52.50
128	65098	Product 127	50.10
129	65007	Product 128	50.10
130	65043	Product 129	36.00
131	68220	Product 130	145.00
132	68219	Product 131	50.10
133	68200	Product 132	68.00
134	68218	Product 133	98.00
135	68217	Product 134	34.00
136	40152	Product 135	158.00
137	87779	Product 136	85.00
138	65005	Product 137	34.00
139	65220	Product 138	129.00
140	65219	Product 139	49.00
141	68209	Product 140	34.00
142	68223	Product 141	98.00
143	68226	Product 142	34.00
144	68199	Product 143	170.00
145	68196	Product 144	98.00
146	68202	Product 145	29.50
147	68195	Product 146	34.00
148	68208	Product 147	98.00
149	65163	Product 148	85.00
150	68201	Product 149	41.00
151	65081	Product 150	52.00
152	68222	Product 151	158.00
153	68221	Product 152	85.00
154	68214	Product 153	31.00
155	65055	Product 154	85.00
Sheet1

 

[MThies]

Eostar price book 9.1.21.xlsx
	A	B	C
1	Item #	Product	Base price
2	58777	Product 1	28.00
3	58734	Product 2	78.00
4	58711	Product 3	28.00
5	58779	Product 4	89.00
6	58762	Product 5	89.00
7	58787	Product 6	33.00
8	58729	Product 7	28.00
9	58703	Product 8	28.00
10	58716	Product 9	135.00
11	58742	Product 10	80.00
12	58702	Product 11	28.00
13	58728	Product 12	28.00
14	58749	Product 13	78.00
15	58712	Product 14	28.00
16	59306	Product 15	28.00
17	58704	Product 16	28.00
18	58714	Product 17	30.00
19	98004	Product 18	112.00
20	98001	Product 19	40.00
21	98007	Product 20	40.00
22	98002	Product 21	89.00
23	98005	Product 22	85.00
24	98006	Product 23	135.00
25	98003	Product 24	85.00
26	54928	Product 25	63.00
27	54953	Product 26	48.00
28	54931	Product 27	230.00
29	54946	Product 28	105.00
30	54945	Product 29	63.00
31	54973	Product 30	63.00
32	54972	Product 31	48.00
33	54970	Product 32	48.00
34	63013	Product 33	29.00
35	49703	Product 34	153.00
36	49702	Product 35	66.00
37	49740	Product 36	23.50
38	49708	Product 37	29.50
39	49704	Product 38	29.50
40	49747	Product 39	29.50
41	49700	Product 40	23.45
42	49701	Product 41	31.45
43	49710	Product 42	34.00
44	49750	Product 43	31.45
45	49716	Product 44	31.45
46	49751	Product 45	31.45
47	49744	Product 46	29.50
48	49743	Product 47	34.00
49	49739	Product 48	31.45
50	49752	Product 49	31.45
51	49734	Product 50	29.50
52	49753	Product 51	29.50
53	49746	Product 52	29.50
54	79743	Product 53	45.00
55	62641	Product 54	26.80
56	62642	Product 55	30.60
57	62640	Product 56	26.80
58	06000	Product 57	20.40
59	06002	Product 58	25.50
60	06001	Product 59	24.00
61	98701	Product 60	30.00
62	40520	Product 61	175.00
63	40502	Product 62	53.00
64	40503	Product 63	175.00
65	40505	Product 64	53.00
66	40514	Product 65	61.00
67	40507	Product 66	53.00
68	40513	Product 67	53.00
69	40515	Product 68	150.00
70	40518	Product 69	53.00
71	82023	Product 70	25.50
72	93122	Product 71	48.48
73	99990	Product 72	125.00
74	68188	Product 73	21.00
75	68213	Product 74	27.20
76	65035	Product 75	170.00
77	65016	Product 76	98.00
78	65094	Product 77	29.50
79	65021	Product 78	40.95
80	65212	Product 79	34.00
81	65015	Product 80	34.00
82	65078	Product 81	38.95
83	68207	Product 82	59.00
84	65001	Product 83	31.00
85	65221	Product 84	179.00
86	64197	Product 85	105.00
87	65195	Product 86	36.00
88	65103	Product 87	129.00
89	65059	Product 88	158.00
90	65029	Product 89	85.00
91	68189	Product 90	31.00
92	1066	Product 91	31.00
93	68206	Product 92	31.00
94	65027	Product 93	31.00
95	65080	Product 94	34.90
96	68216	Product 95	34.00
97	65075	Product 96	105.84
98	68190	Product 97	125.00
99	68175	Product 98	158.00
100	68176	Product 99	85.00
101	68174	Product 100	31.00
102	68173	Product 101	31.00
103	68210	Product 102	31.00
104	68171	Product 103	31.00
105	68172	Product 104	34.90
106	53893	Product 105	196.00
107	65068	Product 106	125.00
108	65020	Product 107	49.00
109	65047	Product 108	160.00
110	65032	Product 109	90.00
111	65017	Product 110	34.00
112	10086	Product 111	155.00
113	40431	Product 112	169.00
114	65031	Product 113	105.00
115	65030	Product 114	36.00
116	65172	Product 115	145.00
117	68187	Product 116	50.10
118	65019	Product 117	140.00
119	64999	Product 118	170.00
120	64998	Product 119	98.00
121	65000	Product 120	34.00
122	77381	Product 121	78.75
123	65046	Product 122	120.00
124	68212	Product 123	29.50
125	65008	Product 124	235.00
126	65009	Product 125	145.00
127	10422	Product 126	52.50
128	65098	Product 127	50.10
129	65007	Product 128	50.10
130	65043	Product 129	36.00
131	68220	Product 130	145.00
132	68219	Product 131	50.10
133	68200	Product 132	68.00
134	68218	Product 133	98.00
135	68217	Product 134	34.00
136	40152	Product 135	158.00
137	87779	Product 136	85.00
138	65005	Product 137	34.00
139	65220	Product 138	129.00
140	65219	Product 139	49.00
141	68209	Product 140	34.00
142	68223	Product 141	98.00
143	68226	Product 142	34.00
144	68199	Product 143	170.00
145	68196	Product 144	98.00
146	68202	Product 145	29.50
147	68195	Product 146	34.00
148	68208	Product 147	98.00
149	65163	Product 148	85.00
150	68201	Product 149	41.00
151	65081	Product 150	52.00
152	68222	Product 151	158.00
153	68221	Product 152	85.00
154	68214	Product 153	31.00
155	65055	Product 154	85.00
Sheet1

Rhodes 101 Price Comparison.xlsx
	B	C
1	Product	BasePrice
2	Product 1	109.00
3	Product 2	134.00
4	Product 3	29.95
5	Product 4	20.40
6	Product 5	58.70
7	Product 6	58.70
8	Product 7	58.70
9	Product 8	68.25
10	Product 9	25.65
11	Product 10	28.75
12	Product 11	28.75
13	Product 12	25.65
14	Product 13	85.00
15	Product 14	102.00
16	Product 15	35.90
17	Product 16	35.90
18	Product 17	35.90
19	Product 18	35.90
20	Product 19	35.90
21	Product 20	14.22
22	Product 21	14.22
23	Product 22	25.10
24	Product 23	25.50
25	Product 24	29.95
26	Product 25	21.70
27	Product 26	24.70
28	Product 27	114.00
29	Product 28	17.30
30	Product 29	14.40
31	Product 30	19.90
32	Product 31	19.90
33	Product 32	19.20
34	Product 33	19.20
35	Product 34	21.70
36	Product 35	24.70
37	Product 36	17.90
38	Product 37	22.35
39	Product 38	25.50
40	Product 39	27.70
41	Product 40	27.70
42	Product 41	27.70
43	Product 42	27.70
44	Product 43	26.50
45	Product 44	79.00
46	Product 45	81.00
47	Product 46	27.20
48	Product 47	125.90
49	Product 48	98.90
50	Product 49	78.00
51	Product 50	174.00
52	Product 51	14.30
53	Product 52	19.90
54	Product 53	28.00
55	Product 54	27.20
56	Product 55	27.20
57	Product 56	24.00
58	Product 57	12.80
59	Product 58	13.40
60	Product 59	15.70
61	Product 60	17.95
62	Product 61	14.40
63	Product 62	14.40
64	Product 63	15.70
65	Product 64	14.85
66	Product 65	16.80
67	Product 66	25.50
68	Product 67	24.00
69	Product 68	25.50
70	Product 69	114.00
71	Product 70	17.30
72	Product 71	14.40
73	Product 72	14.40
74	Product 73	19.90
75	Product 74	19.90
76	Product 75	19.20
77	Product 76	12.75
78	Product 77	19.20
79	Product 78	21.70
80	Product 79	24.70
81	Product 80	17.90
82	Product 81	29.95
83	Product 82	27.00
84	Product 83	33.45
85	Product 84	33.45
86	Product 85	33.45
87	Product 86	25.10
88	Product 87	25.10
89	Product 88	33.45
90	Product 89	14.40
91	Product 90	19.90
92	Product 91	19.90
93	Product 92	21.70
94	Product 93	17.90
95	Product 94	14.90
96	Product 95	13.40
97	Product 96	14.90
98	Product 97	14.90
99	Product 98	14.40
100	Product 99	5.00
101	Product 100	25.15
102	Product 101	25.15
103	Product 102	22.60
104	Product 103	27.70
105	Product 104	31.00
106	Product 105	130.45
107	Product 106	116.90
108	Product 107	116.90
109	Product 108	27.15
110	Product 109	26.25
111	Product 110	31.50
112	Product 111	26.25
113	Product 112	26.40
114	Product 113	27.15
115	Product 114	15.00
116	Product 115	15.00
117	Product 116	16.45
118	Product 117	15.00
119	Product 118	15.00
120	Product 119	47.50
121	Product 120	108.00
122	Product 121	118.00
123	Product 122	28.40
124	Product 123	23.40
125	Product 124	23.40
126	Product 125	29.95
127	Product 126	15.65
128	Product 127	15.65
129	Product 128	15.65
130	Product 129	15.65
131	Product 130	15.65
132	Product 131	15.65
133	Product 132	28.75
134	Product 133	28.75
135	Product 134	26.50
136	Product 135	22.95
137	Product 136	25.00
138	Product 137	23.40
139	Product 138	18.95
140	Product 139	25.58
141	Product 140	26.50
142	Product 141	26.95
143	Product 142	31.00
144	Product 143	31.00
145	Product 144	31.00
146	Product 145	31.00
147	Product 146	31.00
148	Product 147	31.00
149	Product 148	26.95
150	Product 149	25.15
151	Product 150	25.15
152	Product 151	11.39
153	Product 152	11.39
154	Product 153	11.39
155	Product 154	11.39
156	Product 155	11.39
157	Product 156	15.00
158	Product 157	15.00
159	Product 158	13.20
160	Product 159	13.40
161	Product 160	16.80
162	Product 161	19.30
163	Product 162	19.30
164	Product 163	25.50
165	Product 164	33.45
166	Product 165	25.50
167	Product 166	23.40
168	Product 167	23.40
169	Product 168	25.50
170	Product 169	25.50
171	Product 170	23.40
172	Product 171	23.50
173	Product 172	23.20
174	Product 173	23.20
175	Product 174	23.50
176	Product 175	23.50
177	Product 176	23.50
178	Product 177	25.50
179	Product 178	28.50
180	Product 179	26.80
181	Product 180	27.00
182	Product 181	27.00
183	Product 182	26.80
184	Product 183	33.45
185	Product 184	27.00
186	Product 185	27.00
187	Product 186	27.00
Sheet1

 

[MThies]

Rhodes 101 Price Comparison.xlsx
	B	C
1	Product	BasePrice
2	Product 1	109.00
3	Product 2	134.00
4	Product 3	29.95
5	Product 4	20.40
6	Product 5	58.70
7	Product 6	58.70
8	Product 7	58.70
9	Product 8	68.25
10	Product 9	25.65
11	Product 10	28.75
12	Product 11	28.75
13	Product 12	25.65
14	Product 13	85.00
15	Product 14	102.00
16	Product 15	35.90
17	Product 16	35.90
18	Product 17	35.90
19	Product 18	35.90
20	Product 19	35.90
21	Product 20	14.22
22	Product 21	14.22
23	Product 22	25.10
24	Product 23	25.50
25	Product 24	29.95
26	Product 25	21.70
27	Product 26	24.70
28	Product 27	114.00
29	Product 28	17.30
30	Product 29	14.40
31	Product 30	19.90
32	Product 31	19.90
33	Product 32	19.20
34	Product 33	19.20
35	Product 34	21.70
36	Product 35	24.70
37	Product 36	17.90
38	Product 37	22.35
39	Product 38	25.50
40	Product 39	27.70
41	Product 40	27.70
42	Product 41	27.70
43	Product 42	27.70
44	Product 43	26.50
45	Product 44	79.00
46	Product 45	81.00
47	Product 46	27.20
48	Product 47	125.90
49	Product 48	98.90
50	Product 49	78.00
51	Product 50	174.00
52	Product 51	14.30
53	Product 52	19.90
54	Product 53	28.00
55	Product 54	27.20
56	Product 55	27.20
57	Product 56	24.00
58	Product 57	12.80
59	Product 58	13.40
60	Product 59	15.70
61	Product 60	17.95
62	Product 61	14.40
63	Product 62	14.40
64	Product 63	15.70
65	Product 64	14.85
66	Product 65	16.80
67	Product 66	25.50
68	Product 67	24.00
69	Product 68	25.50
70	Product 69	114.00
71	Product 70	17.30
72	Product 71	14.40
73	Product 72	14.40
74	Product 73	19.90
75	Product 74	19.90
76	Product 75	19.20
77	Product 76	12.75
78	Product 77	19.20
79	Product 78	21.70
80	Product 79	24.70
81	Product 80	17.90
82	Product 81	29.95
83	Product 82	27.00
84	Product 83	33.45
85	Product 84	33.45
86	Product 85	33.45
87	Product 86	25.10
88	Product 87	25.10
89	Product 88	33.45
90	Product 89	14.40
91	Product 90	19.90
92	Product 91	19.90
93	Product 92	21.70
94	Product 93	17.90
95	Product 94	14.90
96	Product 95	13.40
97	Product 96	14.90
98	Product 97	14.90
99	Product 98	14.40
100	Product 99	5.00
101	Product 100	25.15
102	Product 101	25.15
103	Product 102	22.60
104	Product 103	27.70
105	Product 104	31.00
106	Product 105	130.45
107	Product 106	116.90
108	Product 107	116.90
109	Product 108	27.15
110	Product 109	26.25
111	Product 110	31.50
112	Product 111	26.25
113	Product 112	26.40
114	Product 113	27.15
115	Product 114	15.00
116	Product 115	15.00
117	Product 116	16.45
118	Product 117	15.00
119	Product 118	15.00
120	Product 119	47.50
121	Product 120	108.00
122	Product 121	118.00
123	Product 122	28.40
124	Product 123	23.40
125	Product 124	23.40
126	Product 125	29.95
127	Product 126	15.65
128	Product 127	15.65
129	Product 128	15.65
130	Product 129	15.65
131	Product 130	15.65
132	Product 131	15.65
133	Product 132	28.75
134	Product 133	28.75
135	Product 134	26.50
136	Product 135	22.95
137	Product 136	25.00
138	Product 137	23.40
139	Product 138	18.95
140	Product 139	25.58
141	Product 140	26.50
142	Product 141	26.95
143	Product 142	31.00
144	Product 143	31.00
145	Product 144	31.00
146	Product 145	31.00
147	Product 146	31.00
148	Product 147	31.00
149	Product 148	26.95
150	Product 149	25.15
151	Product 150	25.15
152	Product 151	11.39
153	Product 152	11.39
154	Product 153	11.39
155	Product 154	11.39
156	Product 155	11.39
157	Product 156	15.00
158	Product 157	15.00
159	Product 158	13.20
160	Product 159	13.40
161	Product 160	16.80
162	Product 161	19.30
163	Product 162	19.30
164	Product 163	25.50
165	Product 164	33.45
166	Product 165	25.50
167	Product 166	23.40
168	Product 167	23.40
169	Product 168	25.50
170	Product 169	25.50
171	Product 170	23.40
172	Product 171	23.50
173	Product 172	23.20
174	Product 173	23.20
175	Product 174	23.50
176	Product 175	23.50
177	Product 176	23.50
178	Product 177	25.50
179	Product 178	28.50
180	Product 179	26.80
181	Product 180	27.00
182	Product 181	27.00
183	Product 182	26.80
184	Product 183	33.45
185	Product 184	27.00
186	Product 185	27.00
187	Product 186	27.00
Sheet1

Rhodes 101 Price Comparison.xlsx
	A	B	C
1	Item #	Product	BasePrice
2	340059	Product 1	109.00
3	340159	Product 2	134.00
4	49701	Product 3	29.95
5	06000	Product 4	20.40
6	570136	Product 5	58.70
7	570125	Product 6	58.70
8	570173	Product 7	58.70
9	17103	Product 8	68.25
10	17109	Product 9	25.65
11	17110	Product 10	28.75
12	17158	Product 11	28.75
13	17161	Product 12	25.65
14	224005	Product 13	85.00
15	224005	Product 14	102.00
16	536015	Product 15	35.90
17	536007	Product 16	35.90
18	536009	Product 17	35.90
19	536006	Product 18	35.90
20	536012	Product 19	35.90
21	870137	Product 20	14.22
22	870139	Product 21	14.22
23	92907	Product 22	25.10
24	92906	Product 23	25.50
25	92902	Product 24	29.95
26	14012	Product 25	21.70
27	14038	Product 26	24.70
28	14301	Product 27	114.00
29	14235	Product 28	17.30
30	14230	Product 29	14.40
31	14223	Product 30	19.90
32	14209	Product 31	19.90
33	14246	Product 32	19.20
34	14239	Product 33	19.20
35	14210	Product 34	21.70
36	14238	Product 35	24.70
37	14224	Product 36	17.90
38	14150	Product 37	22.35
39	67035	Product 38	25.50
40	67013	Product 39	27.70
41	67012	Product 40	27.70
42	67052	Product 41	27.70
43	67040	Product 42	27.70
44	67049	Product 43	26.50
45	607104	Product 44	79.00
46	607102	Product 45	81.00
47	53013	Product 46	27.20
48	540043	Product 47	125.90
49	541005	Product 48	98.90
50	590348	Product 49	78.00
51	590353	Product 50	174.00
52	72870	Product 51	14.30
53	01209	Product 52	19.90
54	73810	Product 53	28.00
55	62402	Product 54	27.20
56	62413	Product 55	27.20
57	62422	Product 56	24.00
58	00109	Product 57	12.80
59	00126	Product 58	13.40
60	00133	Product 59	15.70
61	00122	Product 60	17.95
62	16835	Product 61	14.40
63	16635	Product 62	14.40
64	16616	Product 63	15.70
65	16633	Product 64	14.85
66	16617	Product 65	16.80
67	07602	Product 66	25.50
68	07518	Product 67	24.00
69	07517	Product 68	25.50
70	01901	Product 69	114.00
71	02035	Product 70	17.30
72	02028	Product 71	14.40
73	02018	Product 72	14.40
74	02027	Product 73	19.90
75	02009	Product 74	19.90
76	02046	Product 75	19.20
77	02005	Product 76	12.75
78	02039	Product 77	19.20
79	02010	Product 78	21.70
80	02036	Product 79	24.70
81	02024	Product 80	17.90
82	92812	Product 81	29.95
83	92662	Product 82	27.00
84	92850	Product 83	33.45
85	92660	Product 84	33.45
86	92838	Product 85	33.45
87	92631	Product 86	25.10
88	92663	Product 87	25.10
89	92858	Product 88	33.45
90	01618	Product 89	14.40
91	01627	Product 90	19.90
92	01609	Product 91	19.90
93	01610	Product 92	21.70
94	01624	Product 93	17.90
95	06834	Product 94	14.90
96	07135	Product 95	13.40
97	07134	Product 96	14.90
98	07034	Product 97	14.90
99	07033	Product 98	14.40
100	09809	Product 99	5.00
101	67409	Product 100	25.15
102	67435	Product 101	25.15
103	67423	Product 102	22.60
104	67412	Product 103	27.70
105	92659	Product 104	31.00
106	558007	Product 105	130.45
107	558028	Product 106	116.90
108	558033	Product 107	116.90
109	89010	Product 108	27.15
110	89948	Product 109	26.25
111	89175	Product 110	31.50
112	89947	Product 111	26.25
113	89169	Product 112	26.40
114	89960	Product 113	27.15
115	21535	Product 114	15.00
116	21523	Product 115	15.00
117	21533	Product 116	16.45
118	21936	Product 117	15.00
119	21938	Product 118	15.00
120	21940	Product 119	47.50
121	341005	Product 120	108.00
122	341005	Product 121	118.00
123	04822	Product 122	28.40
124	04853	Product 123	23.40
125	04864	Product 124	23.40
126	85308	Product 125	29.95
127	972111	Product 126	15.65
128	972109	Product 127	15.65
129	972110	Product 128	15.65
130	972108	Product 129	15.65
131	972104	Product 130	15.65
132	972106	Product 131	15.65
133	47153	Product 132	28.75
134	48910	Product 133	28.75
135	86076	Product 134	26.50
136	86012	Product 135	22.95
137	86023	Product 136	25.00
138	86051	Product 137	23.40
139	86013	Product 138	18.95
140	88010	Product 139	25.58
141	90004	Product 140	26.50
142	73578	Product 141	26.95
143	73440	Product 142	31.00
144	73429	Product 143	31.00
145	73438	Product 144	31.00
146	73434	Product 145	31.00
147	73431	Product 146	31.00
148	73433	Product 147	31.00
149	73620	Product 148	26.95
150	52513	Product 149	25.15
151	52518	Product 150	25.15
152	850162	Product 151	11.39
153	850164	Product 152	11.39
154	850165	Product 153	11.39
155	850161	Product 154	11.39
156	850163	Product 155	11.39
157	37223	Product 156	15.00
158	37225	Product 157	15.00
159	37224	Product 158	13.20
160	24635	Product 159	13.40
161	24620	Product 160	16.80
162	24653	Product 161	19.30
163	24656	Product 162	19.30
164	49916	Product 163	25.50
165	49956	Product 164	33.45
166	49954	Product 165	25.50
167	49953	Product 166	23.40
168	49946	Product 167	23.40
169	49945	Product 168	25.50
170	49930	Product 169	25.50
171	49940	Product 170	23.40
172	49809	Product 171	23.50
173	49807	Product 172	23.20
174	49807	Product 173	23.20
175	49815	Product 174	23.50
176	49814	Product 175	23.50
177	49844	Product 176	23.50
178	03060	Product 177	25.50
179	932001	Product 178	28.50
180	92927	Product 179	26.80
181	92929	Product 180	27.00
182	92939	Product 181	27.00
183	92931	Product 182	26.80
184	92942	Product 183	33.45
185	92924	Product 184	27.00
186	92924	Product 185	27.00
187	92936	Product 186	27.00
Sheet1

 

[MThies]

Welcome to the Board!

In order to help you set this up, we really need to see the structure of your two lists.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Thanks for the tip! The top spreadsheet I entered is the main sheet. Ignore the middle. The last sheet is the sheet who's prices need checked. Hopefully there is a way to automatically put the price in one sheet next to the correct product in the other sheet by using the Item #.

Thank you,

 

[Joe4]

Take a look at using VLOOKUP, to lookup the value from another range and bring back the value from a different column in the same row:

VLOOKUP Function

The Excel VLOOKUP function is used to retrieve information from a table using a lookup value. The lookup values must appear in the first column of the table, and the information to retrieve is specified by column number. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for...

exceljet.net

Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support

Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.

support.microsoft.com

 

[MThies]

Take a look at using VLOOKUP, to lookup the value from another range and bring back the value from a different column in the same row:

VLOOKUP Function

The Excel VLOOKUP function is used to retrieve information from a table using a lookup value. The lookup values must appear in the first column of the table, and the information to retrieve is specified by column number. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for...

exceljet.net

Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support

Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.

support.microsoft.com

Thanks for the help! I think it solved my issue.

 

[Joe4]

You are welcome!