How to compare 2 sheets and harvest data from one sheet onto the second sheet

kstaver ✭✭✭
edited 01/16/23 in Formulas and Functions

I am comparing 2 versions of a product BOM(one is flat, and the other is organized by sub assemblies and lists critical components). Each BOM is stored in its own Smartsheet Grid. One BOM has vendor and vendor part number information. I want to harvest the vendor and vendor part information from one of the BOMs and insert it into the other BOM. What is is the best formula to do that?

Part numbers are consistent between the two BOMS. We have two versions because they are serving two different purposes. I want to use a formula that looks for the part number in one sheet and then collects the vendor information and puts it into the other sheet.

Is this possible? Help?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!