SUSANMLY,

You will have to do this with VBA. Is this a VBA form your using? If so, put
a dropdown list on the form and in the change event for the list box, use the
vlookup function like this

YourVariable= Application.WorksheetFunction.VLookup(lookupValue, yourRange,
returncolumn)

where the yourRange variable is declared and set as follows:

dim yourRange as Range

Set yourRange= Worksheets(1).Range("AE2:AF5")

the range values in quotes are where your list is defined.

If your actually working in the worksheet and setting up your form there,
the approach would be similar, but the vlookup function will be in your cell
as follows:

=VLookup(lookup cell, AE2:AF5, 2)

This is assuming the value to be returned in the 2nd column of the range. If
you have more than 2 columns in your range, you will need substitute for the
correct column. This method does not get you away from the column where the
item number is diplayed like the VBA method will, but it accomplishes the
need to display the description.

Hope that helps!

Kevin

"SUSANMLY" wrote:


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