Extracting data

[Mark]

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

 

[Ron de Bruin]

Hi Mark

If I understand you correct

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

 

[Guest]

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" <[email protected]> wrote in

message news:[email protected]...

 

[Ron de Bruin]

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

 

[Tom Ogilvy]

Use the Advanced filter from Data=>Filter=>Advanced filter. The cell where
you put the 123 and the cell above it (filled with the word Model) will be
your criteria range. Start from the sheet where you enter the 123 and want
the output.

 

[Ron de Bruin]

Stupid from me this is not working because you have duplicate Model numbers

Why don't you use Data>AutoFilter

 

[Guest]

I thought of that but there are 100's of models.. The
drop down on a filter is just to much to look at.