Y,x lookup

gUTTERMEDIC

New Member
Joined
Sep 16, 2014
Messages
1
I have 30 items that are sold by 10 sales reps. Here is the report I get out of the as400.

520101 10/10 CT LINER CAN LL RL 36X58 55G BLK 365822G 13.00
520144 8/25 CT LINER CAN HD RL 38X60 60G NATURAL HD386017N 4.00
520152 10/10 CT LINER CAN LL 38X58 60G BLK 1.2ML 385830G 4.00
520373 100 CT LINER CAN LL RL 28X45 26G SLIM GRAY 284530G 3.00
Salesrep Totals 36.00
46 TODD
107638 1/ROLL FILM PVC 18" X 2000' CUTTER BOX 30550400 3.00
193275 1/ROLL FILM PVC ZIP SAFE 18"X 2M 30540474 1.00
520004 10/50 CT LINER CAN LL RL 24X32 10-16G GRAY 243222G 1.00
520073 100 CT LINER CAN LL 40X46 45G BLK .9ML 404622G 2.00
520152 10/10 CT LINER CAN LL 38X58 60G BLK 1.2ML 385830G 4.00
Salesrep Totals 11.00
48 CODY
107638 1/ROLL FILM PVC 18" X 2000' CUTTER BOX 30550400 2.00
193275 1/ROLL FILM PVC ZIP SAFE 18"X 2M 30540474 1.00
520073 100 CT LINER CAN LL 40X46 45G BLK .9ML 404622G 2.00
520101 10/10 CT LINER CAN LL RL 36X58 55G BLK 365822G 2.00
520128 8/25 CT LINER CAN HD RL 43X48 56G NATURAL HD434816N 1.00
520152 10/10 CT LINER CAN LL 38X58 60G BLK 1.2ML 385830G 3.00

The report covers one month. I would like to setup excel to enter this date each month and have it show each sale reps
items and how many sold. I know its already here, but need to use the data in charts to make the data visual. Like who sole the most this month. Them use each month on a year chart.

OK my problem is how do I do something like vlookup that will keep the salesmen seperate without having to format the report every month.
 
Last edited:

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,485
Messages
5,831,965
Members
430,098
Latest member
bemmelen

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