How can I achieve the following:-

I wish to see if a value in a column is within another column but only
if the value in a 2nd column is greater than Zero, if it is there and
greater than Zero return "Issue", otherwise ""

The value I wish to look for is in Col A Sheet1
The target 1st Column is Col A Sheet2
The target 2nd Column is Col S Sheet2

I wish to display the Result in Col C Sheet1


Thanks