How to compare columns of data between two worksheets and replace with adjacent data?

[ktjackson]

I need a function that compares data on one worksheet to data in a second worksheet and if it finds a match, replace adjacent data in the first worksheet with the matching adjacent data in the second worksheet. I have a list of UPCs on Sheet1, and a shorter list of UPCs on Sheet2. Sheet1 has incorrect pricing, while Sheet2 has correct pricing. I need Excel to compare UPCs from Sheet1 to the UPCs in Sheet2, and ,if it finds a match, replace the adjacent price in Sheet1 with the adjacent price in Sheet2. If someone could explain how that is done it will seriously, seriously make my day.

[outofthehat]

VLOOKUP. See attached. Sheet 1 has a list of UPCs. Sheet 2 has a shorter list.
Column C of sheet 1 uses VLOOKUP to select the price off sheet 2 ,where it exists. Where it doesn't, it returns #N/A.

[ktjackson]

VLOOKUP. See attached. Sheet 1 has a list of UPCs. Sheet 2 has a shorter list.
Column C of sheet 1 uses VLOOKUP to select the price off sheet 2 ,where it exists. Where it doesn't, it returns #N/A.

You, sir, are a saint. Thanks so much.