Choosing an item from a list

[Kevlar]

First Post, so go easy on me!

I want to be able to enter a partial part description in one cell an
immediatly after pressing enter have a list of matches received from
complete part #/description list residing on another sheet in th
workbook ,display in the column to the right. For example,

My complete list looks like this and resides on Sheet2:

partno description
1001 STL 1/16X1/8 48x120
1002 STL 1/16X1/8 36X120
1003 ALU 1/16X1/8 48X120
1004 ALU 1/16X1/8 36X120
1005 ALU 1/16X3/8 48X120
1006 S/S 1/16X1/8 48X120
1007 S/S 1/16X1/8 36X120

When I enter STL 1/16 into a cell on Sheet1 and press enter, th
following should show in the adjacent column:

1001 STL 1/16X1/8 48x120
1002 STL 1/16X1/8 36X120

OR

If I enter ALU 1/16x1 and press enter, the following should show in th
adjacent column:

1003 ALU 1/16X1/8 48X120
1004 ALU 1/16X1/8 36X120

Is there anything in excel or VBA that can do that?

I apologize in advance if this is a noob question

 

[Frank Kabel]

Hi
use VLOOKUP. e.g. if you enter somethin in A1 on sheet 1 enter the
following in B1
=if(A1<>"",VLOOKUP(A1,'sheet2'!$A$1:$B$1000,2,0),"")
and copy down

you may also consider using data validation for your entries in column
A (creating a listbox). See
http://www.contextures.com/xlDataVal01.html
for more information about this

 

[Kevlar]

Thank you for your suggestion but this returned #N/A because it coul
not find a unique value.

But I think I was not very clear.

By entering "STL 1/16" in cell A1, I would like the following record
to be displayed or"pasted" in column B from another table on anothe
sheet.

STL 1/16X1/8 16GA 48X120
STL 1/16X1/8 18GA 48X120
STL 1/16X1/8 20GA 36X120
STL 1/16X1/8 20GA 48X120
STL 1/16X1/8 20GA 8.925X18.88
STL 1/16X1/8 22GA 36X120

To further refine my search I would enter STL 1/16X1/8 20GA and th
following would be pasted:

STL 1/16X1/8 20GA 36X120
STL 1/16X1/8 20GA 48X120
STL 1/16X1/8 20GA 8.925X18.88

So basically in cell A1 I am providing a partial description and th
list returned gives me the possible matche

 

[Frank Kabel]

Hi
though this may be possible with formulas have you consideres using a
drop down list (create with data validation -> see the following for
more details: http://www.contextures.com/xlDataVal01.html)

 

[Kevlar]

Yes, I was able to do it that way. This is something that excel novices
will have to use so I was looking for a way to do with fewer steps.