Hello,

I am working on an Excel project in which I need to return one cell
value from an array based on multiple conditions. Let me explain my
example as best I can.

I have an array setup with multiple fields such as:
Year , Product, Location, Revenue

What I need to do is return the cell value in the revenue cell where
for example Year=2005 & Product=C100 & Location=Atlanta. For each
combination like this there is only one possible result to return,
however there are multiple records with year = 2005, Product = C100 and
so on.

Is there a formula or combination of formulas I can use to return my
result?

Thanks so much for your help!


--
rmcnam05
------------------------------------------------------------------------
rmcnam05's Profile: http://www.excelforum.com/member.php...o&userid=27978
View this thread: http://www.excelforum.com/showthread...hreadid=474861