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




.