Multiple lookup function
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
|