| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
some sort of an IF function
what I did.
A list of product codes from J21:J37 and the product description from K21:K37 than the price from L21:L37. In each cell ranging from B21 to B32 I've entered a drop down list containing the list of product codes. In C21 through C32 I want to display the product description which is in the cell right next to the code selected in the B column |
|
#2
|
|||
|
|||
|
try this
type in C21 =VLOOKUP(B21,$J$21:$L$37,2,FALSE) copy this to the other cells in the C column Jaladino wrote in message ... what I did. A list of product codes from J21:J37 and the product description from K21:K37 than the price from L21:L37. In each cell ranging from B21 to B32 I've entered a drop down list containing the list of product codes. In C21 through C32 I want to display the product description which is in the cell right next to the code selected in the B column |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel subtotals, add a sort option, and BOLD the function answers | New Users to Excel | |||
| Sort Function Without Using VBA | Excel Worksheet Functions | |||
| In Excel, why sort function fails when applied to a list of date? | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Linear Mode
