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:

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,877
Members
409,668
Latest member
mitunsLax

This Week's Hot Topics

Top