Need Help with formula: Join(Collect
I am trying to look up multiple criteria (VENDOR PO), (SAP LINE#) referenced in another sheet and return (CPSD) if it matches the criteria.
current formula below I need to edit the highlighted in yellow so it looks up the vendor name and then matches the (VENDOR PO) and (SAP LINE#) to return the (CPSD)
Below is where my formula resides
Below is where I'm pulling information from
Help Article Resources
Check out the Formula Handbook template!