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.