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.