If function to return multiple conditions

[TrishaL]

Hello

Looking for help to write a formula that will give me the result of column "C" below.
Tried this in my excel and obviously not working.... =IF(AND(COUNTIF((AH287="*team*", AJ287=1), "Yes", ""), (AH287="*team*"), AJ287=""), "Pending", ""))
I want it to return Yes if Team and a date, if Team and no date return Pending... everything else just blank.

Thanks in advance

A	B	C
team	23-Jan-19	Yes
single
team		Pending
"this is empty cell"
team	23-Jan-19	Yes
single
"this is empty cell"
team		Pending
team	23-Jan-19	Yes

<colgroup><col><col><col></colgroup><tbody>
</tbody>

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[Fluff]

You're welcome & thanks for the feedback