Index collect from


I have 2 sheets I am working on with;

  1. Sheet #1 (POD Archive) - this is where the entries are logged. A single entry could have multiple PO's in column "PO Number". PO numbers were separated by space.
  2. Sheet #2 (POV) - contains data imported from an external application using Excel - it contains one PO number per record entry.

How can I populate column "POD Entries" in Sheet #2 (POV) if po number is found in Sheet #1 (POD Archive) column "PO Number" and if the number doesn't exist then it will say "No Match"?

Thanks in advance.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!