The SUMPRODUCT formula is used to sum the 3rd column based on the matching
critera of 1st and 2nd column. In this case it might be OK since you dont
have duplicate values...Try out with text values in 3rd column

If this post helps click Yes
---------------
Jacob Skaria


"kimha" wrote:

Pop Year - mo Value
TN 2007-01 88
TN 2007-02 243
TN 2007-03 32
TN 2007-04 69
PA 2007-01 82
PA 2007-02 158
PA 2007-03 34
PA 2007-04 61


So, if Pop = TN and YearMo = 2007-03, return value of 32.

I'm sure there's some sort of way to create embedded IF, AND, and VLOOKUP
statements. I just haven't been able to figure it out.

Thanks-


"Ms-Exl-Learner" wrote:

Provide some examplse.

--------------------
(Ms-Exl-Learner)
--------------------



"kimha" wrote:

How do you perform VLOOKUP with 2 arguments? The 2 arguments are listed in
separate fields within the reference table, columns 1 & 2. When both are
met, I want to return the value in column 3.