Find value based on two criteria
 

How would I write a formula to find the value in column C based on the values
of both column A and B? My table looks like this:
A B C
Month Year Price
7 2009 15.46
8 2009 15.98
9 2009 16.01
10 2009 16.23
11 2009 16.78
12 2009 17.09
1 2010 17.87
2 2010 17.98 and so on...
So I want to find the price when A=7 and B=2009. Thanks so much for your
help!

Find value based on two criteria
 

=SUMPRODUCT((A1:A10=7)*(B1:B10=2009),C1:C10)

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


"StacyM" wrote:

How would I write a formula to find the value in column C based on the values
of both column A and B? My table looks like this:
A B C
Month Year Price
7 2009 15.46
8 2009 15.98
9 2009 16.01
10 2009 16.23
11 2009 16.78
12 2009 17.09
1 2010 17.87
2 2010 17.98 and so on...
So I want to find the price when A=7 and B=2009. Thanks so much for your
help!

Find value based on two criteria
 

I knew it was pretty simple, but I was trying to use the lookup function.
This works great. Thanks for your help!

"Jacob Skaria" wrote:

=SUMPRODUCT((A1:A10=7)*(B1:B10=2009),C1:C10)

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


"StacyM" wrote:

How would I write a formula to find the value in column C based on the values
of both column A and B? My table looks like this:
A B C
Month Year Price
7 2009 15.46
8 2009 15.98
9 2009 16.01
10 2009 16.23
11 2009 16.78
12 2009 17.09
1 2010 17.87
2 2010 17.98 and so on...
So I want to find the price when A=7 and B=2009. Thanks so much for your
help!