I'm trying to create a formula that displays the text contents of any cell in a range in column A, when and cell in a range in column B contains a certain word ("analyst") and column C contains a number greater than zero.

Any help with this?