If Help

[morerockin]

Hello All,

Please see attached spreadsheet.

In Column P, I need a formula that will look in column H and return "Pending CR" IF column H contains "Draft RC Meeting".

[Pete_UK]

You can use this formula in P2:

=IF(ISNUMBER(SEARCH("Draft RC Meeting",H2)),"Pending RC","")

or this one:

=IF(COUNTIF(H2,"*Draft RC Meeting*"),"Pending RC","")

then copy down. You will need to set your Calculation Options to Automatic in order to see the results.

Hope this helps.

Pete