Solved: copy list from one sheet to another sheet

[benong]

hi,
i've a list of data in sheet 2.
eg.


model item
A 1
A 2
A 3
B 1
B 5
B 8
C 2
C 3
C 6

i want to input any model number/s in sheet 1 and the whole list of items for that model will be list out on sheet 3.

eg.
i input "A" in sheet 1 A1 and "C" in sheet 1 A2.
Then when i go to sheet 3, i can see the following list:


model item
A 1
A 2
A 3
C 2
C 3
C 6

How can this be done?

[Bob Phillips]

On Sheet3:

A1:=Sheet2!A1
A2:=IF(NOT(ISNUMBER(SMALL(IF(Sheet2!$A$1:$A$20=Sheet1!$A$1,ROW(Sheet2!$A$1: $A$20)),ROW(A1)))),"",
INDEX(Sheet2!A$2:A$10,SMALL(IF(Sheet2!$A$1:$A$20=Sheet1!$A$1,ROW(Sheet2!$A$ 1:$A$20)),ROW(A1))))

array-enter A2

copy A2 down to as far as you need
copy A1:An to B1:Bn

[benong]

Dear xld,

thank you so much.