kimha

Sometimes it is easier to add a helper column that concatenates the
values in the two columns on which you are conditioning your VLOOKUP.
If you add a column A with the formula =A2&B2 copied down all your
data rows and you have your "lookup conditions" in B10 and C10 you can
use

=VLOOKUP(B10&C10, A2:D10,4,false)

You can have your Pop and your Year-mo as variables in B10 and C10 and
you can hide column A.

Good luck.

Ken
Norfolk, Va

On Oct 12, 12:02*pm, 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.- Hide quoted text -

- Show quoted text -