If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
=if with multiple choices
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) |
#2
|
|||
|
|||
=if with multiple choices
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) "4Proffit" wrote: 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) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I allow multiple choices from table to be entered in colum | JC | Database Design | 4 | January 12th, 2006 08:43 PM |
allowing multiple choices per row in a lookup column | ragen_pruna | General Discussion | 5 | December 6th, 2005 10:41 PM |
How do you select multiple choices in access database dropbox? | FUNPIX | Database Design | 4 | October 30th, 2005 01:52 AM |
Multiple choices in an option group | efg20 | Using Forms | 3 | October 26th, 2005 06:15 PM |
Drop down list with multiple choices | Cindy | Worksheet Functions | 6 | March 30th, 2005 01:35 AM |