Filtered Data into New Worksheet

[bmasella]

In Worksheet A I have hundreds of Rows... Column 2 has a Type in it and not all rows will have a type and then there are various data elements in column 3, 4, 5 and 6

What I would like to do is in a worksheet B have a formula on each of the cells on a row that would look to worksheet A and would find the first row to match the type value in column 2. I would then want to lookup the value of column 3, and 4, and 5 and 6. Then in worksheet B, the next row the formulas in the cells that would also match type and would continue with the NEXT row in worksheet A that matched the type and again retrieve the appropriate cells. It would continue stepping through the rows of worksheet A until I had all of the now displayed in worksheet B

Basically I want to built a subset of worksheet A into worksheet B using the value of the Type column in worksheet A.

I suspect I am going to need to use multiple forumulas nested together in some way to achieve this.

Help?

[Tony Valko]

Sounds like you want something like this...

Lookup with multiple instances of the lookup value:

http://www.excelforum.com/tips-and-t...ml#post3376007

[bmasella]

That was it... made a couple of minor tweaks perfect solution. Thanks again.

[Tony Valko]

You're welcome. Thanks for the feedback!