Index Match Return Without duplicate value

[SAXON10]

Hi,

How to do index match with returning unique value. Column A contain code and B contain text.

Snap shot attached for your reference.

https://www.dropbox.com/s/w1mrqn8x43i26c8/INDEX.PNG?dl=0

Please help me.

DATA
Apple	Text		Bilberry	Text		Watermelon	Text
4398	A1		4410	A1		4411	A11
4397	A1		4410	A1		4411	A11
4408	A1		4410	A1		4411	A11
4409	A1		4410	A1		4411	A11
4587	A1					4411	A11
4413	A4		4398	A2		4411	A11
4400	A1		4398	A2		4411	A11
4412	A1		4398	A2
4379	A1		4398	A2		4400	A12
4401	A1					4400	A12
			4376	A1		4400	A12
			4376	A1		4400	A12
			4376	A1		4400	A12
			4376	A1		4400	A12
						4400	A12

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

RESULT
Apple	Bilberry	Watermelon
4398	4410	4411
4397	4398	4400
4408	4376
4409
4587
4413
4400
4412
4379
4401

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[SAXON10]

Please help me anyone

 

[AhoyNC]

Maybe something like this'
These are array formulas and must be entered with CTRL-Shift-ENTER.

Drag the formulas down the rows as needed.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	Apple	Text		Bilberry	Text		Watermelon	Text		Apple	Bilberry	Watermelon
2	4398	A1		4410	A1		4411	A11		4398	4410	4411
3	4397	A1		4410	A1		4411	A11		4397	4398	4400
4	4408	A1		4410	A1		4411	A11		4408	4376
5	4409	A1		4410	A1		4411	A11		4409
6	4587	A1					4411	A11		4587
7	4413	A4		4398	A2		4411	A11		4413
8	4400	A1		4398	A2		4411	A11		4400
9	4412	A1		4398	A2					4412
10	4379	A1		4398	A2		4400	A12		4379
11	4401	A1					4400	A12		4401
12				4376	A1		4400	A12
13				4376	A1		4400	A12
14				4376	A1		4400	A12
15				4376	A1		4400	A12
16							4400	A12
Sheet