Vlookup (IFS) 3 Condition Model Using Index /Match

[Winship]

Good Afternoon!

Cell I3 (array) in the attached file provides a two condition lookup .... for the conditions in columns F and G. With the two conditions the correct answer is 24.

I need to add a third condition which considers the date entered in cell H:3 from the field D3:D8. Can I3 be amended to address this (and the answer would be the same 24).

By the way, I got the original chart from a forum answer, which is quite frankly amazing stuff, btw.

Thanks!

[tigeravatar]

Index/match solution that does not require array entry (it can be entered like any other regular formula:

Please Login or Register  to view this content.

However, since you are getting numbers instead of text as the result, you could simply use a Sumifs:

Please Login or Register  to view this content.

[Winship]

Perfectly amazing. Both do the trick. Now just need to review so that I understand the syntax. The sumifs item is something out of this world, btw.

Will mark as elegantly solved!

Enjoy your Friday and Have a Better Weekend! In fact, take the rest of the day "off!"