I am working on a pricing spreadsheeet.

In one column I have all of the products and next to it the price
ie: a14 prices is listed in C14

by the customer info (same worksheet) I have created a drop down validation
lookup list of the product codes in A14 through A27. It works fine.

So at the top of the worksheet if I input the product code using the drop
down, how do I populate the price next to it? The below formula works to look
up one item, but what if the input is a15 price is in c15, a16, a17, etc.
Then the pricing would be represented in c15, c16, or C17 etc.

ie: =IF(A14,C14)