=if with multiple choices

[4Proffit]

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)

 

[Duke Carey]

If the drop down is in cell A1 and you want the price in B1, use this formula
in B1. The formula assumes the table of products & prices is in range
A14:c:25

=vlookup(A1,A14:C25,3,0)