Is this possible ?

[daniel]

Hi,

I have following case :

sheet 1:

cell A1:A6 = heading (customer, name A,B,C,D,E)
cell B1:B6 = heading, sold amount last year for each customer (can be 0)
cell C1:C6 = heading, sold amount last month for each customer (can be 0)
cell D16 = heading, sold amount this month for each customer (can be 0)

sheet 2 :

cell A1:A6 = customers, (heading,A,B,C,D,E)
cell B1:B6 = PPG1 (heading, 0,0,0,0,0)
cell C1:C6 = PPG2 (heading, 0,1,1,0,0)
cell D16 = PPG 3 (heading, 0,0,1,1,0)

cell B26 are filled with a formula (=IF(sheet1!B1>0;0;IF(sheet1!AB1=0;1 *
IF(sheet1!BB1>0;1;0);0))
cell B11 ahve following formula =COUNTIF(B3:B6;1)

Now for the tricky part

In sheet 3 I need the following (cell A3:A6 have the heading PPG1 to PPG3) :

Cells B3:B6 need to be blank when the contents of cell sheet2!B1 is 0
cells B3:B6 need to have the customer name when the contents of cell
sheet2!B1 is 1
cells B3:B6 need to have the 1st customer, and cells C3:C6 need to have the
second customer when the content of cells sheet2!B1 = 2.

For the first 2 conditions, I have the formula =IF(sheet2!B1=0;"
";IF(sheet2!B1=1;DGET(sheet2!$A$3:$A$6;1;H1:H2);"MORE"))

What formula do I need for cells D36 (or more)

Thanks for the help.

please respond to : daniel dot hermans at eu dot omron dot com