With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, February 23, 2018
yogi_look up a value in a cell that has multiple values in that cell
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.