In C1:

=VLOOKUP(A1,Sheet1!A1:C5,3,FALSE)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jkb66" wrote in message ...
|I have a value in column A on sheet 3, I want it to match a value in column A
| in sheet 1, then I want the corresponding number from column c on sheet 1 to
| populate column c on sheet 3.