=if with multiple choices

4

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)
 
D

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top