I am trying to use a set of sheets for material tracking from various suppliers without actually having to have my employees use several sheets to do it. I am wondering if there is a way/formula to look through a specific column for a supplier name, and in whichever row it finds said supplier it then outputs that entire row as a result. I would use this to build individual supplier sheets for review while allowing our production staff to only have to monitor/edit one sheet.
