Help Searching Mutiple Job#
I want to be able to insert in my table the information: PO,Project Description,Customer,Payment Teams,Business Unit,Submitter,Notes from anothe sheet that contains the Job information. From the Job# column, I've done it before with an index match but only when is one project.
I want to be able to do it for multiple Job Number that are in the Job # column separeted by a " - "
In this example will be Job 123, Job 124 and Job 125.
Is there any way to do this?
Help Article Resources
Check out the Formula Handbook template!