You need to find notes that mention “needs pickup.” Use a Boolean flag to find them quickly, then read the notes before changing any statuses.

Search inside the note on each row

Put “Needs pickup at 4” in B2 and “Returned to the desk” in B3. Use =ISNUMBER(SEARCH("needs pickup",B2)) in C2 and fill down. The results are TRUE and FALSE. A capitalized version also matches. A blank note returns FALSE.

Needs pickup at 4 is flagged, and Returned to the desk is not.

Illustrated phrase matching. SEARCH ignores letter case.

Read the surrounding words before acting

“No longer needs pickup” still contains the phrase, so the flag is TRUE. Keep a separate status field for decisions. If your search phrase includes a literal question mark or asterisk, put a tilde before it to escape the wildcard.

No longer needs pickup is flagged for human review.

Illustrated context check. A text hit can describe a canceled pickup.

Microsoft’s SEARCH function reference