search list for values
 

I am following the Ashish Mathur article (excel 2003 online help) on "looking
up values in a list to return mulitple corresponding values" and it works
fine. However, I need to base it on one more criteria. My list contains
columns for mfg line, customer, month, and qty. My first criteria is mfg
line and returning multiple customers. Using his article, I get the
customers for all months but I want to return only those customers in a
particular month. How can I revise my formula? Below is what I have so far
(entered as an array)...

=IF(ISERROR(INDEX('Source Data'!A$3:B7800,SMALL(IF('Source
Data'!A$3:A7800=MOR!A$5,ROW('Source Data'!A$3:A7800)),ROW('Source
Data'!1:2)),2)),"",INDEX('Source Data'!A$3:B7800,SMALL(IF('Source
Data'!A$3:A7800=MOR!A$5,ROW('Source Data'!A$3:A7800)),ROW('Source
Data'!1:2)),2))