IF two different conditions are met

[AnnaV]

How do I enter a formula where two different conditions have to be met?

I have specific numbers in column A and names in column B and a numbe
in column C. I want the formula to state if column A has a specifie
number and column B has a specified name and both conditions are me
then return number from column C otherwise return 0.

HELP

 

[MACRE0]

=if(a1=#,if(b1="NAME",C1,0),0) and fill down

where # is the specific number condition to be met
and "NAME" is the specific name condition to be met.

or


=if(and(a1=#,b1="NAME"),C1,0) both will work

 

[Bernard Liengme]

=IF(AND(A1=6,B1="George",C1,"")

last argument is two quotes side-by-side with no space between

best wishes

 

[Jason Morin]

Try:

=IF(MATCH(E1,rng_a,0)=MATCH(F1,rng_b,0),INDEX(rng_c,MATCH
(1,(rng_a=E1)*(rng_b=F1),0)),0)

Array-entered (press ctrl/shift/enter), where:

rng_a = range of numbers in col. A
rng_b = range of names in col. B
rng_c = range of numbers in col. C to return
E1 = number to search for in col. A
F1 = name to search for in col. B

HTH
Jason
Atlanta, GA