Separate data in a list according to reference list

[phithack]

SHEET 1

	A	B	C	D	E	F	G	H	I	J	K
1						FRUIT				OTHER
2	NAME	QTY	PRICE		NAME	QTY	PRICE		NAME	QTY	PRICE
3	APPLE	2	100
4	PINEAPPLE	1	150
5	BAG	3	300
6	BANANA	2	200
7	PENCIL	1	50
8	CALCULATOR	2	275
9	APPLE	5	300
10	STRAWBERRY	3	500

<tbody>
</tbody>

FRUIT LIST

	A	B	C
1	NAME
2	APPLE
3	AVOCADO
4	BANANA
5	BLACKCURRANT
6	DURIAN
7	PAPAYA
8	PINEAPPLE
9	STRAWBERRY

<tbody>
</tbody>

RESULT

	A	B	C	D	E	F	G	H	I	J	K
1						FRUIT				OTHER
2	NAME	QTY	PRICE		NAME	QTY	PRICE		NAME	QTY	PRICE
3	APPLE	2	100		APPLE	2	100		BAG	3	300
4	PINEAPPLE	1	150		PINEAPPLE	1	150		PENCIL	1	50
5	BAG	3	300		BANANA	2	200		CALCULATOR	2	275
6	BANANA	2	200		APPLE	5	300
7	PENCIL	1	50		STRAWBERRY	3	500
8	CALCULATOR	2	275
9	APPLE	5	300
10	STRAWBERRY	3	500

<tbody>
</tbody>

Hi, I have 2 sheets..
First sheet looks like SHEET 1, and the other sheet includes Fruit name list as a reference list..

Can anyone help me with formula for column E, F, G and column I, J, K in Sheet 1 so it would become like table RESULT

Thank you for your help...