Lookup first 4 characters of a cell and output all matches?

[JumboCactuar]

Hi,
If I have data in a cell A2
I want to lookup the first 4 characters of this cell and output all matches in column F which start with these 4 characters

Example: A2 = Auto

Return:
Automatic
Automate
Autograph

Etc...

Thanks for any help

 

[admiral100]

Hi,

Ctrl+Shift+Enter NOT just Enter

G2 =IFERROR(INDEX($F$2:$F$6,MATCH(0,IF($A$2=LEFT($F$2:$F$6,4),COUNTIF($G$1:G1,$F$2:$F$6)),0)),"")

	A	B	C	D	E	F	G
1
2	Auto					Automatic	Automatic
3						Test	Autocad
4						Autocad	Autobiography
5						Test2
6						Autobiography
7

<colgroup><col span="6"><col span="2"></colgroup><tbody>
</tbody>

 

[JumboCactuar]

Hi,

Ctrl+Shift+Enter NOT just Enter

G2 =IFERROR(INDEX($F$2:$F$6,MATCH(0,IF($A$2=LEFT($F$2:$F$6,4),COUNTIF($G$1:G1,$F$2:$F$6)),0)),"")

	A	B	C	D	E	F	G
1
2	Auto					Automatic	Automatic
3						Test	Autocad
4						Autocad	Autobiography
5						Test2
6						Autobiography
7

<tbody>
</tbody>

working Perfectly thankyou