Lookup based 2 criteria

[CakzPrimz]

Dear Folks,

I need to lookup of a quantity plan value based on a Date and Area.
I have 5 columns from B to F

B = Date (is duplicate)
C = Area (is duplicate)
D = Scope of Work
E = Actual
F = Plan

H1 = Date - criteria 1
H2 = Area - criteria 2
H3 = Result

In H3, should be a formula to lookup based on H1 value and H2 value as criteria

Hope somebody could help me.
Thanks in advance.

 

[kweaver]

You didn't say what you wanted to return when you found the two match fields. Oh, you said PLAN which is F column

Try this (change accordingly if you want another column) using CTRL+Shift+Enter (array formula):

=INDEX(F2:F7,MATCH(1,(H1=B2:B7)*(H2=C2:C7),0))

 

[jasonb75]

Given that you mention duplicates, it is unclear from your post if you want all of the results that meet both criteria listed out individually, or just a sum of those results.
Perhaps

=SUMIFS(F:F,B:B,H1,C:C,H2)