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.