I have a workbook with multiple tabs. One tab is a project Bill of materials (6000+ part numbers and quantities) and another tab that is work instruction part numbers and suggested quantities.
I need to match the work instruction part numbers and quantities to the BOM to make sure they are correct and we are ordering the correct quantity.
I built a Vlookup to check part number, but is there a way to verify the part number and pull the quantity in the same formula?
Sample attached
Bookmarks