| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
list dependent cells
i have list in the "H" Column, which has (Critical, major, minor).
A column has AU01 and so on... i wanted to list all the A column values for critical. ex: if H2, H12 and H 23 are selected with critical. and in the result cell, it should display AU02,AU12 and AU23. please give me solution as early as possible... thanks a lot in advance... regards Gireesha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
list dependent cells
Hi,
I'm not sure if you mean this with your AU02 etc codes in column E =IF(H2="Critical",E2,"") or this =IF(H2="Critical","AU"& TEXT(ROW(E2),"00"),"") Mike "GireeshaJ" wrote: i have list in the "H" Column, which has (Critical, major, minor). A column has AU01 and so on... i wanted to list all the A column values for critical. ex: if H2, H12 and H 23 are selected with critical. and in the result cell, it should display AU02,AU12 and AU23. please give me solution as early as possible... thanks a lot in advance... regards Gireesha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a list in a drop down dependent upon another dd list in exc | Excel Discussion (Misc queries) | |||
| Return a list dependent upon the selection of a preceeding list | Excel Worksheet Functions | |||
| create 2nd list dependent on 1st list | Excel Worksheet Functions | |||
| How do I create a dependent list, to a current list? | Excel Discussion (Misc queries) | |||
| How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
Hybrid Mode
