help extracting matching data

[mychals]

If i have data in columns G through I, I want to be able to find all matching data, put in sort order, filter, etc. and post to a column.

Unfort I dont know pivot tables, but pretty good with excel.

Here is an example
http://www.crlaurence.com/adv/example.pdf

This example shows what it would look like if it worked

By entering something in A2, it would look and find all matches in G1:G1000 and post them into B5- and C5-


Thank you for any assistance.

 

[iliace]

What is the problem with using a pivot table?

 

[mychals]

biggest problem is not currently knowing how to do one.

tried tutorials, and brief instruction, and can never seem to get it to work. (frustrating) So I always use a spreadsheet using multiple formulas, and am always looking to get that to work.

 

[iliace]

Did you add headers to your data?

 

[mychals]

I have now, please look at this

http://www.crlaurence.com/adv/example.pdf

 

[iliace]

This is what I meant by headers:

Excel Workbook
	G	H	I
1	Category	Description	Information
2	a123	description 1	more information 1
3	a124	description 2	more information 2
4	a125	description 3	more information 3
5	a123	description 4	more information 4
6	a333	description 5	more information 5
7	a666	description 6	more information 6
8	a123	description 7	more information 7
9	a123	description 8	more information 8
10	a124	description 9	more information 9
11	a125	description 10	more information 10
12	a123	description 11	more information 11
13	a333	description 12	more information 12
14	a666	description 13	more information 13
15	a123	description 14	more information 14
16	a123	description 15	more information 15
17	a124	description 16	more information 16
18	a125	description 17	more information 17
19	a123	description 18	more information 18
20	a333	description 19	more information 19
21	a666	description 20	more information 20
22	a123	description 21	more information 21
23	a123	description 22	more information 22
24	a124	description 23	more information 23
25	a125	description 24	more information 24
26	a123	description 25	more information 25
27	a333	description 26	more information 26
28	a666	description 27	more information 27
29	a123	description 28	more information 28
sheet

So now, using the PivotTable Wizard:

In the last step, I put Category in the page field, and Description and Information in row area. You can now use the drop down for Category to select which ones you want to display. The only thing it won't do is number the rows like you have in your example. But it's far easier than having some nasty-looking, slow multi-cell array formula.

Also, change the location from A1 to A3, otherwise you won't see the page area. I realized that after I took the screenshot.

 

[mychals]

For some reason I am just not getting this, brain dead or something

I now have this

http://www.crlaurence.com/adv/example.pdf



mwsmbsmls@aol.com