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.

[TABLE="width: 439"]
<colgroup><col span="2"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 8"]DATA[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]Text[/TD]
[TD] [/TD]
[TD]Bilberry[/TD]
[TD]Text[/TD]
[TD] [/TD]
[TD]Watermelon[/TD]
[TD]Text[/TD]
[/TR]
[TR]
[TD]4398[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD]4410[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD]4411[/TD]
[TD]A11[/TD]
[/TR]
[TR]
[TD]4397[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD]4410[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD]4411[/TD]
[TD]A11[/TD]
[/TR]
[TR]
[TD]4408[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD]4410[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD]4411[/TD]
[TD]A11[/TD]
[/TR]
[TR]
[TD]4409[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD]4410[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD]4411[/TD]
[TD]A11[/TD]
[/TR]
[TR]
[TD]4587[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4411[/TD]
[TD]A11[/TD]
[/TR]
[TR]
[TD]4413[/TD]
[TD]A4[/TD]
[TD] [/TD]
[TD]4398[/TD]
[TD]A2[/TD]
[TD] [/TD]
[TD]4411[/TD]
[TD]A11[/TD]
[/TR]
[TR]
[TD]4400[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD]4398[/TD]
[TD]A2[/TD]
[TD] [/TD]
[TD]4411[/TD]
[TD]A11[/TD]
[/TR]
[TR]
[TD]4412[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD]4398[/TD]
[TD]A2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4379[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD]4398[/TD]
[TD]A2[/TD]
[TD] [/TD]
[TD]4400[/TD]
[TD]A12[/TD]
[/TR]
[TR]
[TD]4401[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4400[/TD]
[TD]A12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD]4376[/TD]
[TD]A1[/TD]
[TD] [/TD]
[TD]4400[/TD]
[TD]A12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4376[/TD]
[TD]A1[/TD]
[TD][/TD]
[TD]4400[/TD]
[TD]A12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4376[/TD]
[TD]A1[/TD]
[TD][/TD]
[TD]4400[/TD]
[TD]A12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4376[/TD]
[TD]A1[/TD]
[TD][/TD]
[TD]4400[/TD]
[TD]A12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]4400[/TD]
[TD]A12[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 204"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 3"]RESULT

[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]Bilberry[/TD]
[TD]Watermelon[/TD]
[/TR]
[TR]
[TD]4398[/TD]
[TD]4410[/TD]
[TD]4411[/TD]
[/TR]
[TR]
[TD]4397[/TD]
[TD]4398[/TD]
[TD]4400[/TD]
[/TR]
[TR]
[TD]4408[/TD]
[TD]4376[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4409[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4587[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4413[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4400[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4412[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4379[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4401[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[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