find copy paste similar to vlookup but need cell formatting

[msanderson]

Sheet1 has data in column A. Sheet2 has data in column A to C. Want to search for each occurence of data in Sheet1 column A, in Sheet 2 column A and return data from Sheet2 Column C to Sheet1 Column B. If data in Sheet1 (A,1) is found in Sheet2 (A,5) then data from Sheet2 (C,5) should be returned to Sheet1 (B,1).