IF with more conditions

[JimmyBambo]

So this is the issue:
If Name (column A), Surname (column B) and Mark (column C) match with list of Name (Column E); Surname (Column F) and Place (Column G), then answer is YES, otherwise NO.
I tried with =IF(COUNTIFS($E$2:$E$5;A2;$F$2:$F$5;B2;$G$2:$G$4;C2);"YES";"NO"), but didnt get correct results as it looking only on first search cell, not on list.
Thank you in advance

 

[Peter_SSs]

See if this does what you want. I have assumed that all full name combinations are unique.

If is not what you want, please give specifics of where it is wrong and how you would do this manually.

Excel Workbook
	A	B	C	D	E	F	G	H
1	Name	Surname	Mark		Name	Surname	Place
2	Name 1	Surname 1	54		Name 3	Surname 3	1	Yes
3	Name 2	Surname 2	63		Name 9	Surname 2	2	Yes
4	Name 3	Surname 3	89		Name 4	Surname 4	8	No
5	Name 4	Surname 4	38		Name 1	Surname 6	5	No
6	Name 5	Surname 5	50		Name 3	Surname 1	4	Yes
7	Name 1	Surname 6	60
8	Name 3	Surname 1	60
9	Name 4	Surname 8	45
10	Name 9	Surname 2	88
Check Place

 

[RoryA]

Looks like three separate countif formulas to me:

=IF(AND(COUNTIF($E$2:$E$5;A2);COUNTIF($F$2:$F$5;B2);COUNTIF($G$2:$G$4;C2));"YES";"NO")

 

[JimmyBambo]

This actually do that job
Thank you very much.
Also, thank you mr. Peter_SSs for your effort.

 

[Peter_SSs]

Also, thank you mr. Peter_SSs for your effort.

You're welcome but I clearly didn't help & I don't know what happened here - when I reviewed the question, which was well after you posted it, no image was visible in post 1 so my guess about the data looks pretty silly now.