B
bluenoser13
Hello:
I am a newbie to Excel and tis list. I am trying to obtain values fro
the second sheet afer putting criteria from teh first sheet. Here i
teh first sheet:
Sales Results - All Regions
Month -------- (Enter a month number)
Product ---------- (Enter a Product number)
Units Sold ----------- (Result from second sheet)
Products Month
1=Refrigerators 1=Jan 6=Jun 11=Nov
2=Microwaves 2=Feb 7=Jul 12=Dec
3=Ovens 3=Mar 8=Aug 13=Total
4=Dishwashers 4=Apr 9=Sep
5=All products 5=May 10=Oct
Here is a sample of the data from the second sheet:
All Regions
Units Sold
Product ID Jan Feb Mar Apr May Jun
1 1,225 1,074 1,199 1,003 1,157 1,271
2 1,852 1,648 1,670 1,793 1,853 1,963
3 502 562 472 607 570 557
4 578 581 571 584 589 563
5 4,157 3,865 3,912 3,987 4,169 4,354
1=Refrigerators
2=Microwaves
3=Ovens
4=Dishwashers
5=All products
I would like to have these values in the units sold section on th
first sheet. Your assistance is greatly appreciated. :confused
I am a newbie to Excel and tis list. I am trying to obtain values fro
the second sheet afer putting criteria from teh first sheet. Here i
teh first sheet:
Sales Results - All Regions
Month -------- (Enter a month number)
Product ---------- (Enter a Product number)
Units Sold ----------- (Result from second sheet)
Products Month
1=Refrigerators 1=Jan 6=Jun 11=Nov
2=Microwaves 2=Feb 7=Jul 12=Dec
3=Ovens 3=Mar 8=Aug 13=Total
4=Dishwashers 4=Apr 9=Sep
5=All products 5=May 10=Oct
Here is a sample of the data from the second sheet:
All Regions
Units Sold
Product ID Jan Feb Mar Apr May Jun
1 1,225 1,074 1,199 1,003 1,157 1,271
2 1,852 1,648 1,670 1,793 1,853 1,963
3 502 562 472 607 570 557
4 578 581 571 584 589 563
5 4,157 3,865 3,912 3,987 4,169 4,354
1=Refrigerators
2=Microwaves
3=Ovens
4=Dishwashers
5=All products
I would like to have these values in the units sold section on th
first sheet. Your assistance is greatly appreciated. :confused