IF({1},___) Index returning array

[DocAElstein]

	A	B	C	D	E
1	Produnt
2	Name
3	Chocolate-europe aroma	4		Choc	Choc
4	Chocolate-Cookies	0		Choc	Choc
5	Banana-Chocolate-Split	10		Bana	Bana
6	Limette-Käsekuchen	16		Lime	Lime
7	Erdbeere-Quark	8		Erdb	Erdb
8	Erdbeere-Mix	0		Erdb	Erdb
9	Jamaica Sun	6		Jama	Jama
10	Waldbeeren	0		Wald	Wald
11
12
13
14	LOOKUP Table
15	Product Name
16	Haselnuß-Walnuß-aromatisiert
17	Tiramisu		2
18	Chocolate-colonial blend
19	Chocolate-europe aroma		4
20	Chocolate-Cookies
21	Jamaica Sun		6
22	Himbeere-Joghurt
23	Erdbeere-Quark		8
24	Erdbeere-Mix
25	Banana-Chocolate-Split		10
26	Waldbeeren
27	Kirsche		12
28	Kirsche-grüner Apfel

Sheet1

Worksheet Formulas Cell Formula B3 =VLOOKUP(A3,$A$16:$C$33,3,FALSE) B4 =VLOOKUP(A4,$A$16:$C$33,3,FALSE) B5 =VLOOKUP(A5,$A$16:$C$33,3,FALSE) B6 =VLOOKUP(A6,$A$16:$C$33,3,FALSE) B7 =VLOOKUP(A7,$A$16:$C$33,3,FALSE) B8 =VLOOKUP(A8,$A$16:$C$33,3,FALSE) B9 =VLOOKUP(A9,$A$16:$C$33,3,FALSE) B10 =VLOOKUP(A10,$A$16:$C$33,3,FALSE) D3 =LEFT(A3,4) D4 =LEFT(A4,4) D5 =LEFT(A5,4) D6 =LEFT(A6,4) D7 =LEFT(A7,4) D8 =LEFT(A8,4) D9 =LEFT(A9,4) D10 =LEFT(A10,4)