Try this array formula** :

=INDEX(WorkSheet!P1:P370,MATCH(1,(WorkSheet!A1:A37 0=B9)*(WorkSheet!C1:C370=C9),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)


--
Biff
Microsoft Excel MVP


"RobN" wrote in message
...
Is it possible to use something like this formula, amended as required, to
have it display the text from the cell where the first two parts of the
formula are true?
=SUMPRODUCT(--(WorkSheet!$A$1:$A$370=$B9),--(WorkSheet!$C$1:$C$370=$C9),WorkSheet!P$1:P$370)
Or is something totally different needed? Could someone please show what
the formula would need to be?

Rob