Hi Susan

you said that you wanted to be "able to type in the item # from the 1st
worksheet and the description will
appear instead of the item #."

to do this requires using VBA in an worksheet_change event ... however, if
you wanted to type the item# in one cell and return the description in an
adjacent cell it is just a matter of using a VLOOKUP formula instead.

the VLOOKUP formula would be
=VLOOKUP(A1,Sheet1!$A$1:$B$100,2,0)
which says, lookup the value in A1 of this sheet, in the table of
information in Sheet1 range A1 to B100, when a match is found return the
information from the second column of the table, but only if it is an exact
match.

Hope this helps
Cheers
JulieD



"SUSANMLY" wrote in message
...

Hi all, I know enough about excel to get by but I'm trying to create a
form and need some formula help. If anyone can help I would appreciate
it. This is some what complicated so here goes.

I have 2 worksheets- the 1st is a list of item #'s in one column with
their corresponding description in another column.

the second worksheet is a form and what I'm wanting to do is to be able
to type in the item # from the 1st worksheet and the description will
appear instead of the item #.

Is this possible?


--
SUSANMLY
------------------------------------------------------------------------
SUSANMLY's Profile:
http://www.excelforum.com/member.php...o&userid=10269
View this thread: http://www.excelforum.com/showthread...hreadid=319690