How to Update Price List
 

Each month I receive an updated price list spreadsheet (Sheet1) for
some items on an inventory list. Col "A" contains the part numbers and
Col "D" contains the new prices. How do I update a master inventory
spreadsheet pricing (same workbook, but on Sheet2) that lists part
numbers in random order (some blank cells) in Col "B" and old pricing
in Col "F"?