Sheet Comparison/Auto fill

MThies

New Member
Joined
Sep 1, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
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,
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,136
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Sep 1, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
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
ABC
1Item #ProductBase price
258777Product 128.00
358734Product 278.00
458711Product 328.00
558779Product 489.00
658762Product 589.00
758787Product 633.00
858729Product 728.00
958703Product 828.00
1058716Product 9135.00
1158742Product 1080.00
1258702Product 1128.00
1358728Product 1228.00
1458749Product 1378.00
1558712Product 1428.00
1659306Product 1528.00
1758704Product 1628.00
1858714Product 1730.00
1998004Product 18112.00
2098001Product 1940.00
2198007Product 2040.00
2298002Product 2189.00
2398005Product 2285.00
2498006Product 23135.00
2598003Product 2485.00
2654928Product 2563.00
2754953Product 2648.00
2854931Product 27230.00
2954946Product 28105.00
3054945Product 2963.00
3154973Product 3063.00
3254972Product 3148.00
3354970Product 3248.00
3463013Product 3329.00
3549703Product 34153.00
3649702Product 3566.00
3749740Product 3623.50
3849708Product 3729.50
3949704Product 3829.50
4049747Product 3929.50
4149700Product 4023.45
4249701Product 4131.45
4349710Product 4234.00
4449750Product 4331.45
4549716Product 4431.45
4649751Product 4531.45
4749744Product 4629.50
4849743Product 4734.00
4949739Product 4831.45
5049752Product 4931.45
5149734Product 5029.50
5249753Product 5129.50
5349746Product 5229.50
5479743Product 5345.00
5562641Product 5426.80
5662642Product 5530.60
5762640Product 5626.80
5806000Product 5720.40
5906002Product 5825.50
6006001Product 5924.00
6198701Product 6030.00
6240520Product 61175.00
6340502Product 6253.00
6440503Product 63175.00
6540505Product 6453.00
6640514Product 6561.00
6740507Product 6653.00
6840513Product 6753.00
6940515Product 68150.00
7040518Product 6953.00
7182023Product 7025.50
7293122Product 7148.48
7399990Product 72125.00
7468188Product 7321.00
7568213Product 7427.20
7665035Product 75170.00
7765016Product 7698.00
7865094Product 7729.50
7965021Product 7840.95
8065212Product 7934.00
8165015Product 8034.00
8265078Product 8138.95
8368207Product 8259.00
8465001Product 8331.00
8565221Product 84179.00
8664197Product 85105.00
8765195Product 8636.00
8865103Product 87129.00
8965059Product 88158.00
9065029Product 8985.00
9168189Product 9031.00
921066Product 9131.00
9368206Product 9231.00
9465027Product 9331.00
9565080Product 9434.90
9668216Product 9534.00
9765075Product 96105.84
9868190Product 97125.00
9968175Product 98158.00
10068176Product 9985.00
10168174Product 10031.00
10268173Product 10131.00
10368210Product 10231.00
10468171Product 10331.00
10568172Product 10434.90
10653893Product 105196.00
10765068Product 106125.00
10865020Product 10749.00
10965047Product 108160.00
11065032Product 10990.00
11165017Product 11034.00
11210086Product 111155.00
11340431Product 112169.00
11465031Product 113105.00
11565030Product 11436.00
11665172Product 115145.00
11768187Product 11650.10
11865019Product 117140.00
11964999Product 118170.00
12064998Product 11998.00
12165000Product 12034.00
12277381Product 12178.75
12365046Product 122120.00
12468212Product 12329.50
12565008Product 124235.00
12665009Product 125145.00
12710422Product 12652.50
12865098Product 12750.10
12965007Product 12850.10
13065043Product 12936.00
13168220Product 130145.00
13268219Product 13150.10
13368200Product 13268.00
13468218Product 13398.00
13568217Product 13434.00
13640152Product 135158.00
13787779Product 13685.00
13865005Product 13734.00
13965220Product 138129.00
14065219Product 13949.00
14168209Product 14034.00
14268223Product 14198.00
14368226Product 14234.00
14468199Product 143170.00
14568196Product 14498.00
14668202Product 14529.50
14768195Product 14634.00
14868208Product 14798.00
14965163Product 14885.00
15068201Product 14941.00
15165081Product 15052.00
15268222Product 151158.00
15368221Product 15285.00
15468214Product 15331.00
15565055Product 15485.00
Sheet1
 

MThies

New Member
Joined
Sep 1, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
Eostar price book 9.1.21.xlsx
ABC
1Item #ProductBase price
258777Product 128.00
358734Product 278.00
458711Product 328.00
558779Product 489.00
658762Product 589.00
758787Product 633.00
858729Product 728.00
958703Product 828.00
1058716Product 9135.00
1158742Product 1080.00
1258702Product 1128.00
1358728Product 1228.00
1458749Product 1378.00
1558712Product 1428.00
1659306Product 1528.00
1758704Product 1628.00
1858714Product 1730.00
1998004Product 18112.00
2098001Product 1940.00
2198007Product 2040.00
2298002Product 2189.00
2398005Product 2285.00
2498006Product 23135.00
2598003Product 2485.00
2654928Product 2563.00
2754953Product 2648.00
2854931Product 27230.00
2954946Product 28105.00
3054945Product 2963.00
3154973Product 3063.00
3254972Product 3148.00
3354970Product 3248.00
3463013Product 3329.00
3549703Product 34153.00
3649702Product 3566.00
3749740Product 3623.50
3849708Product 3729.50
3949704Product 3829.50
4049747Product 3929.50
4149700Product 4023.45
4249701Product 4131.45
4349710Product 4234.00
4449750Product 4331.45
4549716Product 4431.45
4649751Product 4531.45
4749744Product 4629.50
4849743Product 4734.00
4949739Product 4831.45
5049752Product 4931.45
5149734Product 5029.50
5249753Product 5129.50
5349746Product 5229.50
5479743Product 5345.00
5562641Product 5426.80
5662642Product 5530.60
5762640Product 5626.80
5806000Product 5720.40
5906002Product 5825.50
6006001Product 5924.00
6198701Product 6030.00
6240520Product 61175.00
6340502Product 6253.00
6440503Product 63175.00
6540505Product 6453.00
6640514Product 6561.00
6740507Product 6653.00
6840513Product 6753.00
6940515Product 68150.00
7040518Product 6953.00
7182023Product 7025.50
7293122Product 7148.48
7399990Product 72125.00
7468188Product 7321.00
7568213Product 7427.20
7665035Product 75170.00
7765016Product 7698.00
7865094Product 7729.50
7965021Product 7840.95
8065212Product 7934.00
8165015Product 8034.00
8265078Product 8138.95
8368207Product 8259.00
8465001Product 8331.00
8565221Product 84179.00
8664197Product 85105.00
8765195Product 8636.00
8865103Product 87129.00
8965059Product 88158.00
9065029Product 8985.00
9168189Product 9031.00
921066Product 9131.00
9368206Product 9231.00
9465027Product 9331.00
9565080Product 9434.90
9668216Product 9534.00
9765075Product 96105.84
9868190Product 97125.00
9968175Product 98158.00
10068176Product 9985.00
10168174Product 10031.00
10268173Product 10131.00
10368210Product 10231.00
10468171Product 10331.00
10568172Product 10434.90
10653893Product 105196.00
10765068Product 106125.00
10865020Product 10749.00
10965047Product 108160.00
11065032Product 10990.00
11165017Product 11034.00
11210086Product 111155.00
11340431Product 112169.00
11465031Product 113105.00
11565030Product 11436.00
11665172Product 115145.00
11768187Product 11650.10
11865019Product 117140.00
11964999Product 118170.00
12064998Product 11998.00
12165000Product 12034.00
12277381Product 12178.75
12365046Product 122120.00
12468212Product 12329.50
12565008Product 124235.00
12665009Product 125145.00
12710422Product 12652.50
12865098Product 12750.10
12965007Product 12850.10
13065043Product 12936.00
13168220Product 130145.00
13268219Product 13150.10
13368200Product 13268.00
13468218Product 13398.00
13568217Product 13434.00
13640152Product 135158.00
13787779Product 13685.00
13865005Product 13734.00
13965220Product 138129.00
14065219Product 13949.00
14168209Product 14034.00
14268223Product 14198.00
14368226Product 14234.00
14468199Product 143170.00
14568196Product 14498.00
14668202Product 14529.50
14768195Product 14634.00
14868208Product 14798.00
14965163Product 14885.00
15068201Product 14941.00
15165081Product 15052.00
15268222Product 151158.00
15368221Product 15285.00
15468214Product 15331.00
15565055Product 15485.00
Sheet1
Rhodes 101 Price Comparison.xlsx
BC
1ProductBasePrice
2Product 1109.00
3Product 2134.00
4Product 329.95
5Product 420.40
6Product 558.70
7Product 658.70
8Product 758.70
9Product 868.25
10Product 925.65
11Product 1028.75
12Product 1128.75
13Product 1225.65
14Product 1385.00
15Product 14102.00
16Product 1535.90
17Product 1635.90
18Product 1735.90
19Product 1835.90
20Product 1935.90
21Product 2014.22
22Product 2114.22
23Product 2225.10
24Product 2325.50
25Product 2429.95
26Product 2521.70
27Product 2624.70
28Product 27114.00
29Product 2817.30
30Product 2914.40
31Product 3019.90
32Product 3119.90
33Product 3219.20
34Product 3319.20
35Product 3421.70
36Product 3524.70
37Product 3617.90
38Product 3722.35
39Product 3825.50
40Product 3927.70
41Product 4027.70
42Product 4127.70
43Product 4227.70
44Product 4326.50
45Product 4479.00
46Product 4581.00
47Product 4627.20
48Product 47125.90
49Product 4898.90
50Product 4978.00
51Product 50174.00
52Product 5114.30
53Product 5219.90
54Product 5328.00
55Product 5427.20
56Product 5527.20
57Product 5624.00
58Product 5712.80
59Product 5813.40
60Product 5915.70
61Product 6017.95
62Product 6114.40
63Product 6214.40
64Product 6315.70
65Product 6414.85
66Product 6516.80
67Product 6625.50
68Product 6724.00
69Product 6825.50
70Product 69114.00
71Product 7017.30
72Product 7114.40
73Product 7214.40
74Product 7319.90
75Product 7419.90
76Product 7519.20
77Product 7612.75
78Product 7719.20
79Product 7821.70
80Product 7924.70
81Product 8017.90
82Product 8129.95
83Product 8227.00
84Product 8333.45
85Product 8433.45
86Product 8533.45
87Product 8625.10
88Product 8725.10
89Product 8833.45
90Product 8914.40
91Product 9019.90
92Product 9119.90
93Product 9221.70
94Product 9317.90
95Product 9414.90
96Product 9513.40
97Product 9614.90
98Product 9714.90
99Product 9814.40
100Product 995.00
101Product 10025.15
102Product 10125.15
103Product 10222.60
104Product 10327.70
105Product 10431.00
106Product 105130.45
107Product 106116.90
108Product 107116.90
109Product 10827.15
110Product 10926.25
111Product 11031.50
112Product 11126.25
113Product 11226.40
114Product 11327.15
115Product 11415.00
116Product 11515.00
117Product 11616.45
118Product 11715.00
119Product 11815.00
120Product 11947.50
121Product 120108.00
122Product 121118.00
123Product 12228.40
124Product 12323.40
125Product 12423.40
126Product 12529.95
127Product 12615.65
128Product 12715.65
129Product 12815.65
130Product 12915.65
131Product 13015.65
132Product 13115.65
133Product 13228.75
134Product 13328.75
135Product 13426.50
136Product 13522.95
137Product 13625.00
138Product 13723.40
139Product 13818.95
140Product 13925.58
141Product 14026.50
142Product 14126.95
143Product 14231.00
144Product 14331.00
145Product 14431.00
146Product 14531.00
147Product 14631.00
148Product 14731.00
149Product 14826.95
150Product 14925.15
151Product 15025.15
152Product 15111.39
153Product 15211.39
154Product 15311.39
155Product 15411.39
156Product 15511.39
157Product 15615.00
158Product 15715.00
159Product 15813.20
160Product 15913.40
161Product 16016.80
162Product 16119.30
163Product 16219.30
164Product 16325.50
165Product 16433.45
166Product 16525.50
167Product 16623.40
168Product 16723.40
169Product 16825.50
170Product 16925.50
171Product 17023.40
172Product 17123.50
173Product 17223.20
174Product 17323.20
175Product 17423.50
176Product 17523.50
177Product 17623.50
178Product 17725.50
179Product 17828.50
180Product 17926.80
181Product 18027.00
182Product 18127.00
183Product 18226.80
184Product 18333.45
185Product 18427.00
186Product 18527.00
187Product 18627.00
Sheet1
 

MThies

New Member
Joined
Sep 1, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Rhodes 101 Price Comparison.xlsx
BC
1ProductBasePrice
2Product 1109.00
3Product 2134.00
4Product 329.95
5Product 420.40
6Product 558.70
7Product 658.70
8Product 758.70
9Product 868.25
10Product 925.65
11Product 1028.75
12Product 1128.75
13Product 1225.65
14Product 1385.00
15Product 14102.00
16Product 1535.90
17Product 1635.90
18Product 1735.90
19Product 1835.90
20Product 1935.90
21Product 2014.22
22Product 2114.22
23Product 2225.10
24Product 2325.50
25Product 2429.95
26Product 2521.70
27Product 2624.70
28Product 27114.00
29Product 2817.30
30Product 2914.40
31Product 3019.90
32Product 3119.90
33Product 3219.20
34Product 3319.20
35Product 3421.70
36Product 3524.70
37Product 3617.90
38Product 3722.35
39Product 3825.50
40Product 3927.70
41Product 4027.70
42Product 4127.70
43Product 4227.70
44Product 4326.50
45Product 4479.00
46Product 4581.00
47Product 4627.20
48Product 47125.90
49Product 4898.90
50Product 4978.00
51Product 50174.00
52Product 5114.30
53Product 5219.90
54Product 5328.00
55Product 5427.20
56Product 5527.20
57Product 5624.00
58Product 5712.80
59Product 5813.40
60Product 5915.70
61Product 6017.95
62Product 6114.40
63Product 6214.40
64Product 6315.70
65Product 6414.85
66Product 6516.80
67Product 6625.50
68Product 6724.00
69Product 6825.50
70Product 69114.00
71Product 7017.30
72Product 7114.40
73Product 7214.40
74Product 7319.90
75Product 7419.90
76Product 7519.20
77Product 7612.75
78Product 7719.20
79Product 7821.70
80Product 7924.70
81Product 8017.90
82Product 8129.95
83Product 8227.00
84Product 8333.45
85Product 8433.45
86Product 8533.45
87Product 8625.10
88Product 8725.10
89Product 8833.45
90Product 8914.40
91Product 9019.90
92Product 9119.90
93Product 9221.70
94Product 9317.90
95Product 9414.90
96Product 9513.40
97Product 9614.90
98Product 9714.90
99Product 9814.40
100Product 995.00
101Product 10025.15
102Product 10125.15
103Product 10222.60
104Product 10327.70
105Product 10431.00
106Product 105130.45
107Product 106116.90
108Product 107116.90
109Product 10827.15
110Product 10926.25
111Product 11031.50
112Product 11126.25
113Product 11226.40
114Product 11327.15
115Product 11415.00
116Product 11515.00
117Product 11616.45
118Product 11715.00
119Product 11815.00
120Product 11947.50
121Product 120108.00
122Product 121118.00
123Product 12228.40
124Product 12323.40
125Product 12423.40
126Product 12529.95
127Product 12615.65
128Product 12715.65
129Product 12815.65
130Product 12915.65
131Product 13015.65
132Product 13115.65
133Product 13228.75
134Product 13328.75
135Product 13426.50
136Product 13522.95
137Product 13625.00
138Product 13723.40
139Product 13818.95
140Product 13925.58
141Product 14026.50
142Product 14126.95
143Product 14231.00
144Product 14331.00
145Product 14431.00
146Product 14531.00
147Product 14631.00
148Product 14731.00
149Product 14826.95
150Product 14925.15
151Product 15025.15
152Product 15111.39
153Product 15211.39
154Product 15311.39
155Product 15411.39
156Product 15511.39
157Product 15615.00
158Product 15715.00
159Product 15813.20
160Product 15913.40
161Product 16016.80
162Product 16119.30
163Product 16219.30
164Product 16325.50
165Product 16433.45
166Product 16525.50
167Product 16623.40
168Product 16723.40
169Product 16825.50
170Product 16925.50
171Product 17023.40
172Product 17123.50
173Product 17223.20
174Product 17323.20
175Product 17423.50
176Product 17523.50
177Product 17623.50
178Product 17725.50
179Product 17828.50
180Product 17926.80
181Product 18027.00
182Product 18127.00
183Product 18226.80
184Product 18333.45
185Product 18427.00
186Product 18527.00
187Product 18627.00
Sheet1
Rhodes 101 Price Comparison.xlsx
ABC
1Item #ProductBasePrice
2340059Product 1109.00
3340159Product 2134.00
449701Product 329.95
506000Product 420.40
6570136Product 558.70
7570125Product 658.70
8570173Product 758.70
917103Product 868.25
1017109Product 925.65
1117110Product 1028.75
1217158Product 1128.75
1317161Product 1225.65
14224005Product 1385.00
15224005Product 14102.00
16536015Product 1535.90
17536007Product 1635.90
18536009Product 1735.90
19536006Product 1835.90
20536012Product 1935.90
21870137Product 2014.22
22870139Product 2114.22
2392907Product 2225.10
2492906Product 2325.50
2592902Product 2429.95
2614012Product 2521.70
2714038Product 2624.70
2814301Product 27114.00
2914235Product 2817.30
3014230Product 2914.40
3114223Product 3019.90
3214209Product 3119.90
3314246Product 3219.20
3414239Product 3319.20
3514210Product 3421.70
3614238Product 3524.70
3714224Product 3617.90
3814150Product 3722.35
3967035Product 3825.50
4067013Product 3927.70
4167012Product 4027.70
4267052Product 4127.70
4367040Product 4227.70
4467049Product 4326.50
45607104Product 4479.00
46607102Product 4581.00
4753013Product 4627.20
48540043Product 47125.90
49541005Product 4898.90
50590348Product 4978.00
51590353Product 50174.00
5272870Product 5114.30
5301209Product 5219.90
5473810Product 5328.00
5562402Product 5427.20
5662413Product 5527.20
5762422Product 5624.00
5800109Product 5712.80
5900126Product 5813.40
6000133Product 5915.70
6100122Product 6017.95
6216835Product 6114.40
6316635Product 6214.40
6416616Product 6315.70
6516633Product 6414.85
6616617Product 6516.80
6707602Product 6625.50
6807518Product 6724.00
6907517Product 6825.50
7001901Product 69114.00
7102035Product 7017.30
7202028Product 7114.40
7302018Product 7214.40
7402027Product 7319.90
7502009Product 7419.90
7602046Product 7519.20
7702005Product 7612.75
7802039Product 7719.20
7902010Product 7821.70
8002036Product 7924.70
8102024Product 8017.90
8292812Product 8129.95
8392662Product 8227.00
8492850Product 8333.45
8592660Product 8433.45
8692838Product 8533.45
8792631Product 8625.10
8892663Product 8725.10
8992858Product 8833.45
9001618Product 8914.40
9101627Product 9019.90
9201609Product 9119.90
9301610Product 9221.70
9401624Product 9317.90
9506834Product 9414.90
9607135Product 9513.40
9707134Product 9614.90
9807034Product 9714.90
9907033Product 9814.40
10009809Product 995.00
10167409Product 10025.15
10267435Product 10125.15
10367423Product 10222.60
10467412Product 10327.70
10592659Product 10431.00
106558007Product 105130.45
107558028Product 106116.90
108558033Product 107116.90
10989010Product 10827.15
11089948Product 10926.25
11189175Product 11031.50
11289947Product 11126.25
11389169Product 11226.40
11489960Product 11327.15
11521535Product 11415.00
11621523Product 11515.00
11721533Product 11616.45
11821936Product 11715.00
11921938Product 11815.00
12021940Product 11947.50
121341005Product 120108.00
122341005Product 121118.00
12304822Product 12228.40
12404853Product 12323.40
12504864Product 12423.40
12685308Product 12529.95
127972111Product 12615.65
128972109Product 12715.65
129972110Product 12815.65
130972108Product 12915.65
131972104Product 13015.65
132972106Product 13115.65
13347153Product 13228.75
13448910Product 13328.75
13586076Product 13426.50
13686012Product 13522.95
13786023Product 13625.00
13886051Product 13723.40
13986013Product 13818.95
14088010Product 13925.58
14190004Product 14026.50
14273578Product 14126.95
14373440Product 14231.00
14473429Product 14331.00
14573438Product 14431.00
14673434Product 14531.00
14773431Product 14631.00
14873433Product 14731.00
14973620Product 14826.95
15052513Product 14925.15
15152518Product 15025.15
152850162Product 15111.39
153850164Product 15211.39
154850165Product 15311.39
155850161Product 15411.39
156850163Product 15511.39
15737223Product 15615.00
15837225Product 15715.00
15937224Product 15813.20
16024635Product 15913.40
16124620Product 16016.80
16224653Product 16119.30
16324656Product 16219.30
16449916Product 16325.50
16549956Product 16433.45
16649954Product 16525.50
16749953Product 16623.40
16849946Product 16723.40
16949945Product 16825.50
17049930Product 16925.50
17149940Product 17023.40
17249809Product 17123.50
17349807Product 17223.20
17449807Product 17323.20
17549815Product 17423.50
17649814Product 17523.50
17749844Product 17623.50
17803060Product 17725.50
179932001Product 17828.50
18092927Product 17926.80
18192929Product 18027.00
18292939Product 18127.00
18392931Product 18226.80
18492942Product 18333.45
18592924Product 18427.00
18692924Product 18527.00
18792936Product 18627.00
Sheet1
 

MThies

New Member
Joined
Sep 1, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,136
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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:
 
Solution

MThies

New Member
Joined
Sep 1, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
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:
Thanks for the help! I think it solved my issue.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,136
Office Version
  1. 365
Platform
  1. Windows
You are welcome!
:)
 

Forum statistics

Threads
1,148,241
Messages
5,745,583
Members
423,963
Latest member
lwilson3

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
Top