Hi,

Suppose your data is in range C6:E14 (including the header rows). In
C17:E17 enter the same heading as in C6:E6. In C18:D18, enter TN and
2007-03. In E18, enter the following formula and copy down

=DSUM($C$6:$E$14,E$17,$C$17:D18)-SUM($E$17:E17)

You may enter more data C19:D19 onwards

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"kimha" wrote in message
...
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.