Sorting Find and Assign specified values

Moharam

New Member
Joined
Jan 5, 2022
Messages
8
Office Version
  1. 2016
  2. 2007
Platform
  1. Windows
Item NameFixed Price
Lube OilQty1: 549, Qty2:999, Qty 3: 1399, Qty 4: 1699, Qty 5:
DcapsulesBalancing Figure of Total Order Value,


Book1
ABCD
1Order IDProductsQtyAmount
22018000499678LubeOil11498
32018000499678AppleCiderVinegar11498
42018000499390DCapsules22799
52018000499390LubeOil22799
62018000499802ImmunityBooster11600
72018000499802LubeOil11600
8201800049979430Caps22000
92018000499794MacaRoot12000
102018000499777LubeOil11599
112018000499777DCapsules11599
122018000499265DCapsules22899
132018000499265AppleCiderVinegar12899
142018000499809DCapsules12000
152018000499809LubeOil12000
162018000486403DCapsules22200
172018000486403AppleCiderVinegar12200
182018000486403LubeOil12200
192018000491069DCapsules11400
202018000491069AppleCiderVinegar11400
212018000499236DCapsules11800
222018000499236LubeOil11800
232018000499837DCapsules22498
242018000499837LubeOil12498
Sheet1
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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