G
Guest
I have the following Index/Match formula which will return the value of 9 if
X17=CCC
X18=ORDERQTY
=INDEX($C$3:$F$5,MATCH(X17,$A$3:$A$5,0),MATCH(X18,$C$2:$F$2,0))
Apr-06 Apr-06 Apr-06 Apr-06
CUST PROD QTY VALUE ORDERQTY ORDERVALUE
AAA 999 1 4 7 10
BBB 888 2 5 8 11
CCC 777 3 6 9 12
How do I make it look at a thrid criteria of the date in row 1. Or perhaps
even a fourth criteria of PROD in column B?
Thanks,
Esther
X17=CCC
X18=ORDERQTY
=INDEX($C$3:$F$5,MATCH(X17,$A$3:$A$5,0),MATCH(X18,$C$2:$F$2,0))
Apr-06 Apr-06 Apr-06 Apr-06
CUST PROD QTY VALUE ORDERQTY ORDERVALUE
AAA 999 1 4 7 10
BBB 888 2 5 8 11
CCC 777 3 6 9 12
How do I make it look at a thrid criteria of the date in row 1. Or perhaps
even a fourth criteria of PROD in column B?
Thanks,
Esther