yogi_look up a value in a cell that has multiple values in that cell

Google Spreadsheet   Post  #2380

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-23-2018

question by: Colby Lehew
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/iFyRXjoR4Jk;context-place=mydiscussions
How to Vlook up a value in a cell that has multiple values in that cell

I have a sheet that records shipping & receiving.  I want to cross reference that all the scheduled orders have shipped. However, multiple orders go out on the same truck.   This means there are multiple orders in the same cell.  It also contains how many cases we received which might complicate the situation. I want to be able to Vlook up individual PO to confirm they were sent out. For example, I want to look up 4323753 ( the 3rd one). Bonus if I can get it to say Pass instead of just repeating the number or fail instead of N.A. Is this possible with multiple numbers in the same cell?  I will want the range to be the entire column as this will be an ongoing process.