I have an issue that I am sure involves a pretty simple formula. I have two spreadsheets, one with a bom including part number, and the other is a list of all parts with pricing. I would like to pull the pricing based on the part number from sheet 2 and instert it into the correct place on sheet one so that I have a bom with the correct part price. Please help. Thanks.