Formula in Excel [Closed]

Registration date
Sunday February 28, 2016
Last seen
March 1, 2016
If I have a master document with alpha numeric values in column A lets say for example Sku001 through sku099, in column B is the corresponding value for each Sku...... (like a price list) ..... in column C i have 10 randomly selected Sku's.

sku003, sku0036, sku0051... and so on.....
My question how can use a formula in column D to take that SKU # from Column C, to search for the match in Column A, and put the corresponding value from Colum B and put in Column D.