Return multiple results Excel 2003

[Hmbrown97]

Hi

I am trying to get a formula that will return all possible results from single column. Sample below. I am using 2003 version on a Work computer that I can't access internet on. The list I have actually has over 400 items. Need one that will return results of only partial words are entered. For example, if I enter "abd", it will list anything that has "abd" in the words. I found a formula on the internet, but can't get it to work with this older version.

Complaint
Abd pain
Abdominal cramping
Abdominal swelling
Ankle swelling
Ankle injury
Arm burn
Arm pain

Thank You

 

[mart37]

Map2
	A	B	C	D
1	complait		abd	Cabdriver
2	Abd pain			Abdominal swelling
3	Abdominal cramping			Abdominal cramping
4	Abdominal swelling			Abd pain
5	Ankle swelling
6	Ankle injury
7	Arm burn
8	Arm pain
9	Cabdriver
10	Contain
Sheet1

Cell Formulas
Range	Formula
D1:D10	D1	=IF(ROW()<=COUNT((SEARCH($C$1,$A$1:$A$10))),INDEX($A$1:$A$10,LARGE(ISNUMBER((SEARCH($C$1,$A$1:$A$10)))*ROW($A$1:$A$10),ROW())),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Hmbrown97]

Map2
	A	B	C	D
1	complait		abd	Cabdriver
2	Abd pain			Abdominal swelling
3	Abdominal cramping			Abdominal cramping
4	Abdominal swelling			Abd pain
5	Ankle swelling
6	Ankle injury
7	Arm burn
8	Arm pain
9	Cabdriver
10	Contain
Sheet1

Cell Formulas
Range	Formula
D1:D10	D1	=IF(ROW()<=COUNT((SEARCH($C$1,$A$1:$A$10))),INDEX($A$1:$A$10,LARGE(ISNUMBER((SEARCH($C$1,$A$1:$A$10)))*ROW($A$1:$A$10),ROW())),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

Thank you this works great.