| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down list function help
One way...
Product list in the range B2:B10 Price list in the range C2:C10 Product drop down in B25 =SUMIF(B2:B10,B25,C2:C10) -- Biff Microsoft Excel MVP "doodiehow" wrote in message ... I am trying to perform a task in excell. I have a list of names for products in col B. In col. C I have a list of prices. I need to know how when I use drop down list at the bottom of B col. I can have it pull down corresponding price into col. C. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop-down list with Lookup function? | Excel Discussion (Misc queries) | |||
| Generating a drop-down list from an IF function | New Users to Excel | |||
| Drop-down list compling with If function. | Excel Worksheet Functions | |||
| Validation function that created from another drop down list | Excel Discussion (Misc queries) | |||
| IS THERE ANY PIVOT TABLE DROP LIST FUNCTION? | Excel Worksheet Functions | |||
Threaded Mode
