I thought of that but there are 100's of models.. The
drop down on a filter is just to much to look at.
-----Original Message-----
Stupid from me this is not working because you have
duplicate Model numbers

Why don't you use DataAutoFilter

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message
...
Use Vlookup

Here is a example from a old posting

Data range in Sheet1 = A1:C20 for example

In Sheet2

A1 : 76050
B1 : =VLOOKUP(A1,Sheet1!A1:C20,2,FALSE)

It will look for 76050 in the first column of the data
range and display
the value from the second column (see the number 2 in
the formula)

C1 : =VLOOKUP(A1,Sheet1!A1:C20,3,FALSE)
For the third column


--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message
...
I dont want to create new sheets. This is going to be
used
as a reference. I was originally using a function
like
=IF(A1=1,"",INDEX(DATA!$E$2:$E$3500,MATCH(PCUA!
E6,DATA!
$A$2:$A$3500,0),1)). But the new data is not
formated to
allow this function to work.

In sheet 2 I want to type any Model# and return the
corisponding data.
-----Original Message-----
Hi Mark

If I understand you correct

Try this
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mark" wrote in
message ...
I am having trouble figuring out how to extract
certian
data from one sheet and display onto a different.
I have:
model # desc
123 11 aaaa
123 02 ssss
456 63 dddd
456 78 ffff
789 98 gggg
789 97 hhhh

On a seperate worksheet I want to put Model-123 in
A1
and
have all #'s and desc's populate that match 123.

any help will be appreciated




.





.