IF AND STATEMENTS

[russellday1]

So I have a list of locations in A:A , a list of audits in B:B and list of audit results in C:C

What I want to do in a summary sheets is to say if A1 (Location name) = to any cell in A:A AND B1 (Audit name) is equal to the B:B then return the result in C:C - The two conditions and result need to be on the same row.

I have tried IF AND but it gives me a false unless i specify the cells rather than range

Any help appreciated

 

[Sufiyan97]

Try

Book2
	A	B	C
1	Location Name	Audit Name	Result
2	A	B	B
3	B	D
4	C	E
5	D	F
6	A	B	B
Sheet1

Cell Formulas
Range	Formula
C2:C6	C2	=IF(AND(COUNTIF($A$2:$A$50,A2)>1,COUNTIF($B$2:$B$50,B2)>1),B2,"")

 

[Marcílio_Lobão]

russellday1, Good morning.

I'm not sure if I understood well your question.

Try to use:

=IF(MATCH(A1; A2:A10; 0) = MATCH(B1; B2:B10;0); INDEX(C2:C10; MATCH(A1; A2:A10;0));"Nof found")

Please, tell us if it worked for you.

I hope it helps.