close

I am following the Ashish Mathur article (excel 2003 online help) on quot;looking
up values in a list to return mulitple corresponding valuesquot; 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)),quot;quot;,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))

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()