Can an editable cell be added to a drop down list?

[Phantom6960]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a series of drop down boxes. When you choose a name from the list the next cell in the row shows the company that person works for. I need to add an empty space to the drop down that can be used to enter the name of someone not on the list. Naturally, I need to be able to enter the 'new' person's company in the corresponding 'next' cell in the row. Can this be done?

Here is the formula I'm using to enter the company name:=IF(ISNA(VLOOKUP(C5,Sheet2!$A$2:$B$8,2,FALSE)),"",VLOOKUP(C5,Sheet2!$A$2:$B$8,2,FALSE))

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a series of drop down boxes. When you choose a name from the list the
next cell in the row shows the company that person works for. I need to add an
empty space to the drop down that can be used to enter the name of someone not
on the list. Naturally, I need to be able to enter the 'new' person's company
in the corresponding 'next' cell in the row. Can this be done?

Here is the formula I'm using to enter the company
name:=IF(ISNA(VLOOKUP(C5,Sheet2!$A$2:$B$8,2,FALSE)),"",VLOOKUP(C5,Sheet2!$A$2:
$B$8,2,FALSE))

Sure, used a named range instead of the absolute reference in the formula.
You could use a self defining name, or insert a row into the table and then
sort it so that you did not have to keep redefining the name.

 

[Shane Devenshire]

Hi,

I don't understand - if they are not on the list then VLOOKUP can't find
them even if you could edit the drop down? Is the drop down done via Data
Validation?

Assuming you are using Data Validation, and 2004 not 2008, you could allow
the user to enter a new item and have it added to the list automatically via
VBA. If you are using Data Validation there is an option on the last tab to
change the Style to Information. That option will warn the user that they
are entering an item which is not on the list, but it will let them.
However, the list does not get the name, that is why you would need to use
VBA.