SHEET 1
<tbody>
</tbody>
FRUIT LIST
<tbody>
</tbody>
RESULT
<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...
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...