if or match hmmmmmm

[dlotz]

Ok U have a book with two sheets.
Sheet one has a produciton total at the end of the row.

Say the production total is Q1 on Sheet 1
on Sheet 2
there are for col's
Week 1 Week 2 Week 3 Week 4

BAsed on the date of the report I have a cell in sheet 2 that
will display the correct week, in c3

I would like to match c3 that tells the week I need and then
have the production form sheet one put in the appropriate col.
so if c3= week 1
The production # from sheet one will only be displayed if it is infact week 1

 

[Sean Timmons]

Not sure I have the entire picture, but sounds something like.. in A2:

=if($c$3=A$1,sheet1!$Q$1,"")

and paste across.

do you have some sort of date or somethng in Sheet1 that needs to be checked
to ensure cell Q1 is referring to a week 1 value?

 

[dlotz]

perfecto

Not sure I have the entire picture, but sounds something like.. in A2:

=if($c$3=A$1,sheet1!$Q$1,"")

and paste across.

do you have some sort of date or somethng in Sheet1 that needs to be checked
to ensure cell Q1 is referring to a week 1 value?

 

[dlotz]

Think you could help me out with another problem

Ok I Have a bonus stucture,
It goes on (12) 4 week cycles and and sales have to increase over the period
to hit
loest level of bonus.
Ok to make it real easy, lets so
Cola colb colc cold cole
colf colg
Period / low produciton / bonus /mid produciton /bonus /High production / b
1 >100 $10 bonus, >100 <5000 $20 bonus >1000
$30 b
2 >200
3


and lets say that sheet 2 A1= the period # and b2= the sales $
Pelase advsie

Hi, try this,
=IF(Sheet2!$B$2>Sheet1!B2,IF(Sheet2!$B$2<Sheet1!D2,Sheet1!C2,IF(Sheet2!$B$2<Sheet1!F2,Sheet1!E2,Sheet1!G2)),"Lowest Level not Achieved")

Also make sure in your columns "Low", "Mid" and "High" that you put the
upper limit of that category's sales requirement e.g.

LOW MID HIGH
100 500 1000

If this helps please click "Yes"
<><><><><><><><><><><>




so close,
But that two varible on sheet two;
A1 the periof of the bonus
b2 the amount on $ need to achieve the bonus.

this function works great for period 1, but there are 12 peiod.
morover a1 has text 1st, 2nd, 3rd and on...

The tbl arrey Sheet
col a; the period
col b, the lowest bonus scale
col c, the bonus amount

col d, the middle bonus scale
col e, the bonus amount
col f, the highest bonus scale
col g, the bonus amount

The tble woudl look like this
1st $3250 b$500 $4500 b$1000 $7500 b$2000
2nd$5000 b$500 $7000 b$1000 $10000 b$2000
3rd $600 b$500 $8000 b$1000 $14000 b$ 2000
and on

: