Help Reorganising / Presenting My Data

Thats as I thought. The only thing that changes from Column A to B is the A or B i.e.

.......*"&A$2

.......*"&B$2

When I have put into my new workbook I have the following 2 formulas:

Column A:

=IF(COUNTIF(RESULTS_RR!$AO$3:$AO$40,"*"&A$2)>=ROWS($3:3),INDEX(RESULTS_RR!$A$3:$A$40,SMALL(INDEX((RIGHT(RESULTS_RR!$AO$3:$AO$40,1)=A$2)*ROW(RESULTS_RR!$AO$3:$AO$40),0),ROWS($3:3)+COUNTIF(RESULTS_RR!$AO$3:$AO$40,"<>*"&A$2))),"")

Column B:

=IF(COUNTIF(RESULTS_RR!$AO$3:$AO$40,"*"&B$2)>=ROWS($3:3),INDEX(RESULTS_RR!$A$3:$A$40,SMALL(INDEX((RIGHT(RESULTS_RR!$AO$3:$AO$40,1)=B$2)*ROW(RESULTS_RR!$AO$3:$AO$40),0),ROWS($3:3)+COUNTIF(RESULTS_RR!$AO$3:$AO$40,"<>*"&B$2))),"")

RESULTS_RR!$AO$3:$AO$40 is where my CURRENT PHASE column is.

B$2 is where my PHASE TITLE is to look up.

RESULTS_RR!$A$3:$A$40 is where my PROJECT NAME column is.

...?

dvent