IF, sumif, sumproduct?

[EAH]

I am looking for a formula to go in column C of my second spreadsheet. I want it to find the numbers in column A of the second spreadsheet in column A of the first spreadsheet and then, if the corresponding cell in column C is greater than 0, to bring back a "Yes". I've tried using an IF, a sumif, a sumproduct, and none of them are working. Any ideas or suggestions would be appreciated!

Spreadsheet 1
	A	B	C
1	156	Bill	1567
2	160	Joe	576
3	162	Mary
4	164	Ben
5	184	Will	50
6	188	Frank	686
7	201	Rob	1893
8	214	Paul	867
9	253	William	231
10	301	Sue	520
11	303	Pam	670
12	305	Jason	835
13	306	Gerry
Spreadsheet 2
	A	B	C
1	156	Bill
2	160	Joe
3	184	Will
4	188	Frank
5	201	Rob

<tbody>
</tbody>

 

[njimack]

Custom format the cell as "YES";; (with quotes) and then use:
=SUMPRODUCT(--(Sheet1!$A$1:$A$13=A1),--(Sheet1!$B$1:$B$13=B1),(Sheet1!$C$1:$C$13))

 

[TheCman81]

A vlookup should do the trick

=IF(VLOOKUP(A2,Sheet1!A:C,3,0)>0,"Yes","")

 

[EAH]

Thank you both! TheCman81, exactly what I needed.

 

[TheCman81]

You're welcome! Thanks for the feedback