Lookup and compare part numbers and quantities from 2 sheets

[BryanP97]

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

[etaf]

i'm assuming you mean office 365 NOT 265

you have a space after the qty in column C on work instructions, which i have removed

you could use
=C2=SUMIFS(BOM!$F$2:$F$100,BOM!$D$2:$D$100,'Work Instructions'!A2,BOM!$F$2:$F$100,'Work Instructions'!C2)
copied down to check the qty

That does check the quantity - BUT if you have the partnumber in more than once it will not work
How about - Just using the partnumber
=C2=SUMIFS(BOM!$F$2:$F$100,BOM!$D$2:$D$100,'Work Instructions'!A2)

And will the partnumber appear more than once in the Workinstruction Sheet - is so
then another sumif()
=SUMIF($A$2:$A$100,A2,$C$2:$C$100)=SUMIFS(BOM!$F$2:$F$100,BOM!$D$2:$D$100,'Work Instructions'!A2)


i'm sure there is also a LET or XLOOKUP that will check an array and provide just one formula