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!