Scott --

A
1 US
2 California
3 =IF(AND(A1="US",A2="California"),100,"")

Should do the trick.

HTH

"Scott" wrote:

Hello,

I need some help with a multiple lookup function. I think there's a formula
that can be used as an array with either SUMIF or SUMPRODUCT but I can't
remember all the details.

Example:
A1 US
A2 California
A3 100

Formula: I want the formula to say "If A1 is US" and "if A2 = California,"
then 100.

Thanks in advance,
Scott