Hlookup or Vlookup for certain text in a cell

[CassieL]

Hi, I am trying to extract certain text from a cell, I hope you can help.

[TABLE="width: 500"]
<tbody>[TR]
[TD](AAA)Which system use on {AAA}? 111[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD](BBB) Which system use on {BBB}?222[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD](CCC) Which system use on {CCC}?111[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD](AAA) What type of expenses processed through system? {AAA}-Rent[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD](BBB)What type of expenses processed through system? {BBB}-Rent[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD](AAA) What type of expenses process through system? {AAA}-Utility[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD](CCC) What type of expenses process through system? {CCC)-Utility[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

From above table, I want to run some function to tell me,
1) Which account uses 111?
AAA
CCC
2) Which account uses 222?
BBB
3) Rent that processed through system?
AAA
BBB
4) Utility that processed through system?
AAA
CCC

Please help, I have a list of over 10000 similar question that loop the same question (64 questions) through different account (AAA,BBB,CCC)..

Your help will much appreciated

 

[Rijnsent]

Hi Cassie,
I'm trying to understand what your data looks like, is the whole text in one cell ( "(AAA)Which system use on {AAA}? 111" ) ? My first hunch is to use the search function with * signs, e.g: =SEARCH("*Which system*111";A1) and to add columns after your data for every question, on which you can then use a filter to get your lists of AAA, CCC etc.
Koen