How to lookup when lookup value repeats?

[joe29]

Hi everyone! <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I haven’t had any luck finding an answer to my question using the forum’s search function. Maybe I’m searching with the wrong terminology. Hopefully someone here can help me out or point me in the right direction.<o></o>
<o> </o>
I need a formula or macro that will look up a specified ID number in a specified sheet and return all rows from that sheet containing the ID number.<o></o>
<o> </o>
Example:<o></o>
<o> </o>

• Sheet “Selection”: User enters ID “ABC01” in cell B2 and enters sheet “M2” in cell B3<o></o>

<o> </o>

• Sheet “Model 1”: A data table. Column A is “ID” with a list of ID numbers. Each number can repeat several times. Columns B through D is misc info related to that ID number.<o></o>

<o> </o>

• Sheet “Model 2”: A data table. Column A is “ID” with a list of ID numbers. Each ID number can repeat several times. Columns B through D is misc info related to that ID number. In this example there are 1000 rows total. Of those 1000 rows, 20 rows have “ABC01” in the ID column.

• Sheet “Data”: This should be where the results are pasted. Columns A,B,C,D of any row that contains “ABC01” in column A of sheet “Model 2” should appear on this sheet, “Data”. Therefore, there should only be 20 rows on this sheet.<o></o>

<o> </o>
<o> </o>
Likewise, if the user enters “M1” on the “Selection” sheet, I would like all rows with “ABC01” from the “Model 1” sheet to appear on the “Data” sheet.<o></o>
<o> </o>
I hope that’s enough information. I REALLY appreciate the help.<o></o>
<o> </o>
BTW, I’m using Excel 2003.<o></o>
<o> </o>
Thank you so much.<o></o>