Extract Multiple Data as list from a Table

As shown in attachment, I need a result shown in sheet2. Sheet1 has source data. When I input on ""sheet2 cell B1" category name I need all the related columns with the same category name listed.

Did you forget to add the attachment? Your post doesn't mean much without it.

Pete

Somehow I cannot attach any file. I do not know why but when I click attach button appears a thin white blank box. Any idea why?

Please see attachment. Thank you in advance.

Put this formula in G3 of Sheet1 (coloured blue in the attached file):

=IF(ISNUMBER(SEARCH(Sheet2!$B$1,C3)),MAX(G$2:G2)+1,"-")

then copy down to the bottom of your data.

In Sheet2 you can use this formula in A3:

=IFERROR(INDEX(Sheet1!A:A,MATCH(ROWS($1:1),Sheet1!$G:$G,0)),"")

Copy across into B3:C3, then in C3 you can change the C:C to D:D and then copy that formula across into D3:E3. Then copy the formulae in row 3 down as far as you need - the attached file illustrates this.

Hope this helps.

Pete

Thank you very much Pete.

Working perfectly.

Gokhan

Glad to hear it.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete