display contents of column A

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?

Hi there,

Try putting this formula =IF(AND(B1="analyst",C1>0),A1,"") into your destination cell.

Kind regards,

Robert

HTH