I have a large list of items - what I would like is when someone enters the
item code, the rest of the information (description, etc) fills in. I know I
can do this with AutoComplete - just wondering if there is a better way since
I am using a large list and don't want to type in each item description by
hand.

Check out help on VLOOKUP tables.

Also see Debra Dalgleish's site for more(and better) on VLOOKUP and Data
Validation lists for entering the item code.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP


On Wed, 15 Nov 2006 15:20:01 -0800, jweasl
wrote:

I have a large list of items - what I would like is when someone enters the
item code, the rest of the information (description, etc) fills in. I know I
can do this with AutoComplete - just wondering if there is a better way since
I am using a large list and don't want to type in each item description by
hand.

Hi Gord!
I'm pretty familiar with Vlookup and Data Validation - I already use that in
another instance - but my issue here is I want to type in a cell and then
have the same cell's contents change. Looks like I need a Loop function, and
I have no experience with those :-(

"Gord Dibben" wrote:

Check out help on VLOOKUP tables.

Also see Debra Dalgleish's site for more(and better) on VLOOKUP and Data
Validation lists for entering the item code.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP


On Wed, 15 Nov 2006 15:20:01 -0800, jweasl
wrote:

I have a large list of items - what I would like is when someone enters the
item code, the rest of the information (description, etc) fills in. I know I
can do this with AutoComplete - just wondering if there is a better way since
I am using a large list and don't want to type in each item description by
hand.

You mean you want the code you typed in to be overwritten by the description?

Sounds a little dangerous to me.

How do you account for errors in typing?

You could use event code using Case Select I suppose but with many item codes
that could become quite lengthy.

One of the VBA guru's will come up with something loopy, I'm sure.


Gord

On Wed, 15 Nov 2006 15:48:01 -0800, jweasl
wrote:

Hi Gord!
I'm pretty familiar with Vlookup and Data Validation - I already use that in
another instance - but my issue here is I want to type in a cell and then
have the same cell's contents change. Looks like I need a Loop function, and
I have no experience with those :-(

"Gord Dibben" wrote:

Check out help on VLOOKUP tables.

Also see Debra Dalgleish's site for more(and better) on VLOOKUP and Data
Validation lists for entering the item code.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP


On Wed, 15 Nov 2006 15:20:01 -0800, jweasl
wrote:

I have a large list of items - what I would like is when someone enters the
item code, the rest of the information (description, etc) fills in. I know I
can do this with AutoComplete - just wondering if there is a better way since
I am using a large list and don't want to type in each item description by
hand.

This is a one-time use kind of thing, but great for future learning for
myself. There are no typos, I'm sure of that :-D

"Gord Dibben" wrote:

You mean you want the code you typed in to be overwritten by the description?

Sounds a little dangerous to me.

How do you account for errors in typing?

You could use event code using Case Select I suppose but with many item codes
that could become quite lengthy.

One of the VBA guru's will come up with something loopy, I'm sure.


Gord

On Wed, 15 Nov 2006 15:48:01 -0800, jweasl
wrote:

Hi Gord!
I'm pretty familiar with Vlookup and Data Validation - I already use that in
another instance - but my issue here is I want to type in a cell and then
have the same cell's contents change. Looks like I need a Loop function, and
I have no experience with those :-(

"Gord Dibben" wrote:

Check out help on VLOOKUP tables.

Also see Debra Dalgleish's site for more(and better) on VLOOKUP and Data
Validation lists for entering the item code.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP


On Wed, 15 Nov 2006 15:20:01 -0800, jweasl
wrote:

I have a large list of items - what I would like is when someone enters the
item code, the rest of the information (description, etc) fills in. I know I
can do this with AutoComplete - just wondering if there is a better way since
I am using a large list and don't want to type in each item description by
hand.

There's a sample workbook on my web site that shows a product name and
code in the Data Validation dropdown list. After an item is selected,
the cell shows only the product name. You could adapt this to your
workbook.

On the following page:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for "DV0005 - Data Validation Columns"



jweasl wrote:
I have a large list of items - what I would like is when someone enters the
item code, the rest of the information (description, etc) fills in. I know I
can do this with AutoComplete - just wondering if there is a better way since
I am using a large list and don't want to type in each item description by
hand.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thanks for getting me off the hook Debra<g

Beats the heck out of a gaggle of Case Selects.


Gord

On Wed, 15 Nov 2006 19:48:51 -0500, Debra Dalgleish
wrote:

There's a sample workbook on my web site that shows a product name and
code in the Data Validation dropdown list. After an item is selected,
the cell shows only the product name. You could adapt this to your
workbook.

On the following page:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for "DV0005 - Data Validation Columns"



jweasl wrote:
I have a large list of items - what I would like is when someone enters the
item code, the rest of the information (description, etc) fills in. I know I
can do this with AutoComplete - just wondering if there is a better way since
I am using a large list and don't want to type in each item description by
hand.

Gord Dibben MS Excel MVP

Well, it might be a little easier to maintain. <g

Gord Dibben wrote:
Thanks for getting me off the hook Debra<g

Beats the heck out of a gaggle of Case Selects.


Gord

On Wed, 15 Nov 2006 19:48:51 -0500, Debra Dalgleish
wrote:


There's a sample workbook on my web site that shows a product name and
code in the Data Validation dropdown list. After an item is selected,
the cell shows only the product name. You could adapt this to your
workbook.

On the following page:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for "DV0005 - Data Validation Columns"



jweasl wrote:

I have a large list of items - what I would like is when someone enters the
item code, the rest of the information (description, etc) fills in. I know I
can do this with AutoComplete - just wondering if there is a better way since
I am using a large list and don't want to type in each item description by
hand.


Gord Dibben MS Excel MVP


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html