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))
- May 27 Tue 2008 20:44
search list for values
close
全站熱搜
留言列表
發表留言