How would I add a third (or 4th) critera I also need to be specific with
which area the item was associated with I tried;
=INDEX($G$4:$R$13,MATCH(1,($D$4:$D$13=$D16)*($F$4:
$F$13=YEAR(R$15)),0),MONTH(R$15)*($A$:A$13="Etch Strip"))

Then changing the value in A5 and the result didn't change?


--
TimR
------------------------------------------------------------------------
TimR's Profile: http://www.excelforum.com/member.php...o&userid=27843
View this thread: http://www.excelforum.com/showthread...hreadid=560850