|The table that has the sizes and prices must have the item you are looking up in the first column of the range that you are doing the VLOOKUP from.|
1 S $15.00
2 M $10.00
3 L $ 5.00
With your drop down in C1, D whatever should contain:
Read the Help file on VLOOKUP for a more detailed explanation.