Match three values

[wysie218]

Hi, is it possible to use the Match and index formulas to match three values? For example, right now I'm matching the account and year to pull in the value I need. I need to add a third dimension...match the department, account and year to pull in the value. How can I do that? Help! Thanks.

 

[Hui]

Wysie

Have a read of http://chandoo.org/forums/topic/need-to-retrieve-data-from-3rd-column-based-upon-criteria-in-first-2-columns

which could be extended to 3 columns

If you are retrieving a single value I would use

=Sumproduct((Range=Department)*(Range=Account)*(Range=Year),(Value Range))

set the ranges to the appropriate ranges