Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-down lists in vlookup
I know how to make a vlookup and a dropdown list but i want to know if there
is a way to have the vlookup create a row of info but also allow a dropdown list be in the middle of it so that you can have different options for certain columns. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-down lists in vlookup
a bit more explanation might be helpful but take a look in the help index
for INDIRECT -- Don Guillett SalesAid Software "NAS" wrote in message ... I know how to make a vlookup and a dropdown list but i want to know if there is a way to have the vlookup create a row of info but also allow a dropdown list be in the middle of it so that you can have different options for certain columns. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-down lists in vlookup
"NAS" wrote:
I know how to make a vlookup and a dropdown list but i want to know if there is a way to have the vlookup create a row of info but also allow a dropdown list be in the middle of it so that you can have different options for certain columns. Perhaps just point the vlookup's col_index_num param to a cell which contains the DV housing the selectable numbers: 1,2,3 ... Eg in say, C2: =VLOOKUP(B2,MyTable,$C$1,0) where cell C1 houses the DV to select the desired col_index_num -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-down lists in vlookup
Vlookup table
Proc Operation Measurement Device ---------------------------------------------------------------------- 11 Laser Flat Fabrivsontness The device 12 Press Bend Faro Arm column in the 13 Mill Slot Micrometer vlookup table has drop-down boxs in each cell. So now when i put the vlookup into another table the drop-down lists do not come in. Only the text that displays in the vlookup table comes in. I would like the drop-down lists in there so that i can change the Device type if so desired from the list in the vlookup table. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-down lists in vlookup
Think it's not possible via formulas. A formula can return only an evaluated
value to the cell it's in. It cannot return a "working" DV droplist. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NAS" wrote: Vlookup table Proc Operation Measurement Device ---------------------------------------------------------------------- 11 Laser Flat Fabrivsontness The device 12 Press Bend Faro Arm column in the 13 Mill Slot Micrometer vlookup table has drop-down boxs in each cell. So now when i put the vlookup into another table the drop-down lists do not come in. Only the text that displays in the vlookup table comes in. I would like the drop-down lists in there so that i can change the Device type if so desired from the list in the vlookup table. Orig. post "NAS" wrote: I know how to make a vlookup and a dropdown list but i want to know if there is a way to have the vlookup create a row of info but also allow a dropdown list be in the middle of it so that you can have different options for certain columns. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-down lists in vlookup
Is there another way of doing something like this with another type of
formula or something all together different. "Max" wrote: Think it's not possible via formulas. A formula can return only an evaluated value to the cell it's in. It cannot return a "working" DV droplist. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NAS" wrote: Vlookup table Proc Operation Measurement Device ---------------------------------------------------------------------- 11 Laser Flat Fabrivsontness The device 12 Press Bend Faro Arm column in the 13 Mill Slot Micrometer vlookup table has drop-down boxs in each cell. So now when i put the vlookup into another table the drop-down lists do not come in. Only the text that displays in the vlookup table comes in. I would like the drop-down lists in there so that i can change the Device type if so desired from the list in the vlookup table. Orig. post "NAS" wrote: I know how to make a vlookup and a dropdown list but i want to know if there is a way to have the vlookup create a row of info but also allow a dropdown list be in the middle of it so that you can have different options for certain columns. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-down lists in vlookup
"NAS" wrote:
Is there another way of doing something like this with another type of formula or something all together different. Welcome back <g Afraid I'm out of further suggestions for you Maybe try posting afresh (put in a new post) to garner insights from others -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP specific monthly accounting data by selecting drop down li | Excel Worksheet Functions | |||
Adding sub-menus and actions to data in drop down lists in Excel 2 | Excel Worksheet Functions | |||
Drop Down lists | Excel Discussion (Misc queries) | |||
unrestricting drop down lists | Excel Worksheet Functions | |||
How do I change the appearance of my drop down lists? | Excel Worksheet Functions |