Formula in Excel

Closed
dean94x Posts 3 Registration date Sunday February 28, 2016 Status Member Last seen March 1, 2016 - Feb 28, 2016 at 01:30 PM
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.