Hello,

Thanks in advance for such a great site, everyone has been most helpful.

I have two sheets, Current and Master. The Master sheet has the current pricing that I need to copy to Current Sheet. The common row is "A", this has the model number in both sheets. In the Current sheet, there may be duplicate model numbers in row "A", that is fine, need to update all pricing. I need sheet "Current" to search the "Master" and get the new pricing and copy to "Current".

Sheet Structure,

Master Sheet
Column A (model number)
Column C (price)

Current Sheet
Column A (model Number)
Column F (price)

So Current column "A" needs to check Master "A", if model numbers same update price from Master "C" to Current "F".

Thank you,

JR