Look for values from a different sheet and return it

Hello,

So I am working with a file that has 2 sheets. Sheet 1 has columns A,B,C,D

Sheet 2 has Column. A B C D

For both sheets, column A= Account number, B= Name, C= spread. D= Class

Now Sheet 1 has 500 accounts, with old data in column C. Sheet 2 has 100 accounts with updated data in column C. Data in either account is not in any order (ascending or descending. Can not be an order, as we use a suffix on every account)

Sheet one's 500 accounts include the 100 accounts from sheet 2.

Now I want to put a formula in column C of sheet 1 that will look for the updated values in Sheet 2/Column C and return it on Sheet 1/Column C.

So even though I will drag down the formula in column C, across 500 accounts in Sheet 1, it will only update the value for the accounts that exists in sheet 2. The remaining values will remain as is. I.E. I dont want the remaining accounts to show Zero or N/A.

Please help!!

Thanks in advance.