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.

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.

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



