Maybe...

Excel has an option to use the adjacent (in the same column) entries.

You can toggle that option via:
tools|Options|edit tab|check Enable autocomplete for cell values

Because this uses the previous entries in the column, it'll get smarter each
time you another unique item.

======
The other option is to use a combobox from the control toolbox toolbar. This
does support that kind of feature.

======
Another option if the id's and client names are unique:

Type in the id, then use =vlookup() to return the client name.

You'd have to build a table of id's and client names (on a separate sheet) and
once you build that table, you could use Data|validation to allow the user to
pick the id (but not the autocomplete stuff).

If you want to read more about =vlookup(), visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html

More about Data|Validation??
http://www.contextures.com/xlDataVal01.html

bwall wrote:

I have a question about fill in cells in excel kind of like a list or a
combo box. I have someome that wants to be able to start typing in
excel and have the rest of the characters popup like the url address
does in IE. I don't think that this is possible in excel, but I could
be wrong because I'm not that familiar with it. I would think that it
would have to be backed up by a database for this to work. Could
someone help me on this one. I would like to initially do it with out
a DB behind it. I have ID#'s and Client names that I would like to
popup into the cells after typing a few of the numbers/letters. Is
this possible in Excel??
Thanks
Bob

--
bwall
------------------------------------------------------------------------
bwall's Profile: http://www.excelforum.com/member.php...o&userid=26997
View this thread: http://www.excelforum.com/showthread...hreadid=402012

--

Dave Peterson