Searching for text in a row and producing a list

[internet_andy]

I have a table in A1:BI8 on sheet1.

I am wanting to, on sheet2, search row 5 (from the table on sheet1) for specific text (eg "1D1") and return the corresponding information in row 1 (eg a name).

As there will be multiple matches of specific text ("1D1") can this return all of these matches in one cell or insert a new row below and insert the next name.

Thank you for any help.
Regards, Andy!

[Special-K]

Suggest you change the subject of this post as per Rule 1 before a Mod comes along...

http://www.excelforum.com/forum-rule...rum-rules.html

[internet_andy]

Sorry this is my first time using the forum. Is the subject ok now?

[Special-K]

Prob needs to be more along lines of
"Searching for text in a row and producing a list"
Mods are quite strict on this forum.
In the meantime I'll have a think about it...

[internet_andy]

Brilliant, thanks

[Special-K]

I can do searching rows into a list but have never searched for columns.
Still trying this one cos it would be handy to know how..

[Special-K]

Solution is here
See the answer given about halfway down the page

http://stackoverflow.com/questions/2...om-dynamic-row

[internet_andy]

Thanks Special-K, unfortunately I don't really understand this post

I'll keep trying