[RESOLVED] Excel...Returning values

[vonoventwin]

I have two sheets in Excel.
Sheet1 has Social Security Numbers in Column A
and there names in Column B. This sheet never changes.

Sheet 2 is data that changes daily, but only has SSN's and no names tied to the data. So I want this sheet to grab the cooresponding names from Sheet 1.

I want to write some kind of code that will auto-populate a new column in Sheet2. Basically, in Sheet 2 If Column C's SSN is "something", then it goes and looks at sheet 1 column A finds the SSN, grabs the name out of column B and returns it to the new column in Sheet 2.

I included a small example below... Thanks!