If statement maybe?

[chadlaw32]

I am working on a formula and I have a Name in A31, A percentage in M31, then I have a list of names in Column U. What i need is if that name in A31 is a member of the list in Column u and the percentage is over a set number return a yes. Any ideas?

 

[Fluff]

How about
=IF(AND(COUNTIF(U:U,A31),M31>0.5),"Yes","No")