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))

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

software

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